Re: Optimizing..

"Mark D. Stock" <mdstock@informix.com> offerred: +I have also heard of this method. But if you think about it logically, +one CPUVP per CPU should give you total CPU power. What is happening +with more CPUVPs giving better performance, is that they are being +switched too often. They are then being replaced with another process, +and with so many CPUVPs around, with any luck it is one of them. + +I suggest this goes to process priority. You might try increasing the +priority of your CPUVP processes. I think on HP this is best achieved +manually, as opposed to setting NOAGE. Actually, the number of CPU VPs influence the number of threads spawned for queries. On some platforms (HP for one) the number of threads spawned for the "correct" number of cpuvps winds up being too low for the capacity of the processors. Tuning more than physial processors generates more threads, thus you get higher cpu utilization. As whether this always translates into faster query response is another matter: it might, but it might not. -- Dave Kosenko davek@summitdata.com Director of Training Services (732) 469-4070 Summit Data Group (an Informix Authorized Education Center)