Re: index build performance

Posted in 2007

Obnoxio The Clown — Wed, 18 Apr 2007 17:44:35 +0100 (BST) — source: Usenet: comp.databases.informix

Floyd Wellershaus said: > Thanks. > Yes the table has 6 fragments. > I have 7 cpu's on the box. > So I assume, based on your recommendation to set PSORT_NPROCS to 7 and > have 7 temp dbspaces and set PSORT_DBTEMP to those. > btw, we have nothing else running at the time, so I was planning on using > pdqpriority 100 but for safety leaving MAXPDQPRIORITY to 25. Stick to PSORT_NPROCS=6 then. -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.