Re: Informix Performance Test

Posted in 1998

David J Meyer — 21 Feb 1998 19:53:36 GMT — source: Informix-list mailing list archive (1991-1998)

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 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)