Re: Slow query respons

On Fri, 24 Apr 1998 12:59:06 +0300, Zeljan Silje <zeljan@laus.hr> wrote: > >Hi, > >I am using Informix OnLine5.0? on SCO ODT5.0 (single 133 MHz CPU, 2x1GB >disks, 32MB). > >When I query table with approximately 250 000 rows, query runs very fast >- few seconds (sqlexplain.out shows index path and estimated costs=5). >But, when the same query runs more then one user simultaneously, query >takes about 5 minutes (sqexplain.out shows again index path and >estimated cost=5). > >Any ideas? You don't have much memory on this machine. Have you checked wether it's paging? If it is I would expect this behaviour. With current memory prices I wouldn't run more than one user on a 32Mb machine. If you have to you might have to do some tuning for it. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)