Re: PDQ

From: wisse <wisse@kabelfoon.nl> > >I noticed a performance decrease instead of a performance increase when >using PDQ with creating indexes. > >The create indexes are done one/with: > > * Informix 7.23.UC6 on Solaria 2.5.1. > * System: SUN E4000 with 6 CPU's and 5.3 GB internal memory. > * Informix has four CPU, NOAGE is set, AFFINITY is set for all 4 > Informix CPU's. > * Tables are fragmented round robbin on two dbspaces. > * Indexes has their own dbspace and disk/diskchannel > * All dbspaces are on raw devices > >During the creations of indexes nobody is using the system. When using >PDQ the index creation takes around 10% longer. That is not what I want. Picky, picky, picky. :-) >Monitoring onstat -g mgm tells me hat I have PDQ resources enough. And >other measurements show me that the system has plenty of resources left. > >The question is this a feature of Informix 7.23.UC6 or do I something >wrong. Could you be a bit less specific in how you used PDQ? Get Your Private, Free Email at http://www.hotmail.com