Re: BMT : informix vs. sybase

In article <33065D6B.192C@hei.co.kr>, "hyun-taek." <htshin@hei.co.kr> writes >Hi! everyone > >We had done BMT(Informix vs. sybase) last two weeks. >We had checked "TPS(Transaction per second)". >SYBASE 11.0.2 >INFORMIX 7.2.0 > >We found that TPS of informix is very high at the begining time. >but get decreased tremendously. >I think that Informix writes all data on the memory and >after memory is full, it transfers all data to a disk. >The speed of transfering data to a disk is very slow. >It is just my opinion. >So, Do you have any idea on that ? > > > this is my E-mail address > > htshin@hei.co.kr > > thank you ! Which version of Informix engine (SE/Online, 5/7)? Which version of Sybase? What plaform (HP/Sun/IBM/Sequent/Pyramid)? What operating system and version? What hardware (CPU's/memory/disk/network)? What type of connection (client/server across a network or shared memory)? Using ODBC? Using what database shchema? Using what Informix OnLine configuration? Was it an untuned Online configuration? Remember Online comes supplied with a configuration for a very small instance which uses the least memory/disk and allows you to set it up on very small machines. It needs tuning... -- David Williams