Re: Slow query respons

Zeljan Silje 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? > > +--------------------------------------------------------+ > | CC Computer Consulting d.o.o. | > +--------------------------+-----------------------------+ > | Zeljan Silje | e-mail: zeljan@laus.hr | > | CC Computer Consulting | Tel: +385 (20) 411-136 | > | Janjevska 15 | +385 (1) 6552-330 | > | 20 000 Dubrovnik | Fax: +385 (20) 411-136 | > | Hrvatska (Croatia) | URL: http://www.laus.hr | > +--------------------------+-----------------------------+ Have you tried running "vmstat 10" while the slow queries are running? This will give you info on CPU loading, disk activity, etc. Maybe someone who knows Online can help more. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/