System : OLTP or DSS?

Posted in 2000

Vinod Bhansali — Fri, 02 Jun 2000 22:14:01 GMT — source: Informix-list mailing list archive (1991-1998)

Hi guys, Given a system can we find whether it is a OLTP or DSS without interacting with Users or Developers? I am asking this question as our performance tuning decisions are greatly affected by the application. Even though we can collect information from users/developers about the frequency of queries/insert/deletes/updates, but if the information is not correct, it will affect the tuning and finally the performance of the system. Thanks in advance Vinod Bhansali ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

↪ replying to Vinod Bhansali

David Williams — Sat, 3 Jun 2000 00:01:00 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <8h9de1$5ro$1@news.xmission.com>, Vinod Bhansali <iiug@hotmail.com> writes > >Hi guys, > >Given a system can we find whether it is a OLTP or DSS without interacting >with Users or Developers? > >I am asking this question as our performance tuning decisions are greatly >affected by the application. Even though we can collect information from >users/developers about the frequency of queries/insert/deletes/updates, but >if the information is not correct, it will affect the tuning and finally the >performance of the system. > > You can't, you will need to ask the both sets of people. >Thanks in advance >Vinod Bhansali >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > -- David Williams