Re: Help! Poor performance

Jeff - PDQPRIORITY = 1 will supposedly enable parallal scans only, which is probably perfect for your situation. The other thing is that for KAIO to work, your OS must support it and Informix must use it. We have it on Sun/Solaris, not sure what other platforms it's available on, but I gather it makes a big difference. I haven't tried AIOVP's instead, might be an interesting experiment someday...greg. Jeff Craig wrote: > > Thank you Mr. Berns for your concise and informative comments. You > are correct that rowsize has a lot to do with throughput, and > future "benchmarks" of this type will be based on bytes/second. > The consumer table is fragmented across several dbspaces, but I > have not turned on PDQ, so have not seen the benefit. We have non- > database applications running on the server, so I am trying to > configure a best balance of resources. SGI does not have KAIO > in this release, but we will be looking at v7.20, which may have > it. snip...