Re: Informix Performance Test

My first thought is turn PDQ off. This causes overhead in the engine for non-PDQ enabled operations (such as insert). Then, of course, the normal tuning considerations apply - have **LOTS** of buffers, at least 4 LRUs, one page cleaner / disk. Vic 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) -- Vic Goldberg Manager, DBA Team, Cornell University (607) 254-7441 (Voice) (607) 255-6982 (Fax)