Re: Performance Question on queries per second

In article <6ir71i$g1d@newsops.execpc.com>, Pat Militzer <pmilitzer@ultracom.com> writes >Hi there, > >Does Informix have any rating how many queries per minute that its database >can do? > >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. > ok. >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 ??? Why are 30,000 queries needed? >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 Thats quite fast.. >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? > >We were lead to believe that this could be done in 5 hrs. Is this >something that can be achived? > Depends, what are the queries doing and are they all needed? >Thanks in advanced, > >Pat Militzer >Pmilitzer@ultracom.com > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care