RE: Performance of mid-sized tables?

> When we upgraded our HP from a model F to a dual processor K, with 512MB > RAM, our database slowed down, even though it fit completely in memory. > We have had Informix and HP out here several times to try and fix it, > but they can't. It has been so frustrating that we actually considered > moving to Oracle several times. I don't have much trust in Informix. What version of the OS are you using? I believe there where some major problems with the internal parallelism of the early releases of HPUX 10.x. I further believe that these have been largely fixed in 10.10. But if you want to post details offline, I'd be happy to contribute my 0.02's worth to try and fix your problems... Good luck! Billy