Re: Performance Question on queries per second

On 7 May 1998 02:41:54 GMT, "Pat Militzer" <pmilitzer@ultracom.com> wrote: >Hi there, > >Does Informix have any rating how many queries per minute that its database >can do? What is a "query"??? >Specifically we have Informix 7.23 Dynamic Online Server running on a Sun >UltraEnterprise 4000 with 1.2gig of memory and 4 250mhz Sparc processors. > >The vendor we have states the system is running fine. Though, this >process, which runs about 30,000 queries to find matches and notify the >users that there is a match. This process starts at 1am doesn't finish >until about 12hrs later. The throughput averages between 17-23 queries per >second. For the 1st 5 hours there are only a max of 30 users on the >system after that there is an average of 170 '200 users on the system. By >system, I mean, users accessing the database and running queries through a >front end application. > >Do these numbers sound right? Too high or too low? What does these queries do? On a single processor 300 MHz Intel Pentium machine with SCO Unix and IDS ver. 7.22 UC2 i did queries like this: select integer1, integer2 from table where integerprimarykey = 2000; where the 2000 whas different values repeated for every 300 selects. I created 13500 of these in a file and executed that in dbaccess with output to a file. The result was about 400 queries per second. (34 seconds for the 13500 select statements.) Executing through a programming language where the select could have been prepared first and then executed repetadly whould probably have been faster. If your selects are not significantly more complex something must be wrong. Of course if the where clause doesn't include the primary key you may easily get any kind of results. Do you actually need to execute so many queries? Couldn't it be done via some kind of join or whatever? >We were lead to believe that this could be done in 5 hrs. Is this >something that can be achived? Noone can say unless we see the actual code that is executed. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)