Re: Help! Poor performance
Posted in 1996
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. ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------