Re: Performance question
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.
>
> 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
>