Re: Informix Performance Test

In article <dmeyer9-2102981454400001@ftl-fl6-15.ix.netcom.com>, David J Meyer <dmeyer9@ix.netcom.com> writes >Folks, > > >I have a few things to add to this: > > This application can run multiple-threads > for data going into 6-10 tables at rates > between 1000-2000 rows per second. The > tables have indexes and RI and Informix > and the machine LOVES it...give me more. > The machine this is running on is a monster > .... 4 Processors with a GIG of ram. > > But... > > I do not understand why when concentrating > on one table - no indexes, no logging, one > column do I hit a ceiling of 400 rps. I am Proably there is a spinlock/mutex on the fragment hence inserts into on efragment become single threaded. Remember the extent allocation routines MUST be protected by a mutex. > led to believe that this does not matter > what processing power the machine is configured > with... with one table I can expect only ~400 > rps. > > If there is an Informix Engineer out there, > Please shed some light on this... > > >David Meyer > > > >In article <dmeyer9-1902981632480001@ftl-fl1-06.ix.netcom.com>, >dmeyer9@ix.netcom.com (David J Meyer) wrote: > >> Greetings, >> >> >> I have written a Threaded ODBC application to test >> insert rates into Informix. The operating parameters >> are specified below. >> >> The strange thing is that I can only get 400 rows per >> second inserting into this table. The table has no >> indexes and is spanned over 4 spaces. I know that >> the problem is not ODBC - we are getting roundtrip >> clock rates from 0-15 milliseconds. >> >> Does any one have any ideas of what I can look at >> to raise these rates?... The processor itself can >> handle alot more than this. I dont think it is >> head contention because I used ROUND ROBIN and >> there are no indexes...Logging is Off. >> >> Any ideas to increase inserts > 400 rps >> would be very much appreciated. >> >> David J Meyer >> Guerilla Software >> >> >> Client: Microsoft C++ >> Driver: CLI 2.5 >> Desc: Allows user to select number of threads. >> Will send insert statement through ODBC >> into a test table comprised of one integer column. >> >> Server: Informix 7.13 >> RS6000 4 Processors >> AIX 4.14 AIX >> >> Config: SHMTOTAL 0 >> NUMCPU 4 >> MULTIPROC "Y" >> PDQPRIORITY 75 >> >> Database: No Logging >> LOCK MODE NOT WAIT >> >> Table: one integer column >> No Indexes >> ROUND ROBIN over 4 DB spaces. >> LOCK MODE (ROW) -- 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