Re: CPU usage problems when using KAIO in V7.3? on SINIX.

From: mike@inftec.be (Mike Aerts) > >The database is located on raw devices in which case Informix >uses kernel asynchronous I/O by default. >The problem I try to describe only occurs when I have an SQL-statement >that needs to read a large number of rows and only find a few matches. >In this case when I look into what happens with sar we see the %sys >is abnormally high This is not necessarily unexpected, as the CPU VP is probably having to do a lot of manual comparisons. And because KAIO is so much faster than AIO on your box, you're seeing a more severe impact. [SNIP] >I'm open to all suggestions and requests for further information and tests. onstat -p onstat -R onstat -F $INFORMIXDIR/etc/$ONCONFIG Hardware config (# CPUs, disks, RAM, etc) Is this a single-CPU box? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com