Re: Performance question

In article <01bcf053$bbb14500$57011814@willie>, "Willie L. Meeks" <wmeeks@harrahs.com> writes >I apologize for not sending the onconfig parameters. > >SHMTOTAL 768000 >SHMVIRTSIZE 348000 >DS_TOTAL_MEMORY 614000 >DS_MAX_SCANS 1000 >MAX_PDQPRIORITY 60 >DS_MAX_QUERIES 8 >OPTCOMPIND 2> >Willie L. Meeks <wmeeks@harrahs.com> wrote in article ><01bcefc3$7f535480$57011814@willie>... >> I have a question related to PDQ. Can any one explain to me why when you >> run a query with PDQ enabled it appears that your cpu vp's don't work as >> hard. It appears to me from the results I have observed from my DSS >system >> that if I excute 50 without PDQ enabled the box works hard and the >queries >> complete faster. >> There could be many reasons, I would need an onstat -a to be able to tell you why.. >> When PDQ is enabled the cpu vp's only are working at about 45 to 50 >> percent of capacity as well as sar reports indicate that this is >consistent >> with informix. Can some please give me some advice on possible >performance >> gains. >> >> WM >> -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care