Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
wisse — — source: Informix-list mailing list archive (1991-1998)
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.
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.
Regards,
Albert Wisse
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.