Informix Performance Test
Posted in 1998
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)