Re: Create index very slow

Mike Segel wrote: > > Aww don't take advice from a clown. Especially this one. > (only if he's drunk can you trust him ;-) > > Seriously, does MAX_PDQPRIORITY follow standard UNIX conventions? > The lower the number, the higher the priority? Or should I give up sniffing > glue? You should give up sniffing the glue! Stick to the whisky. :-) MAX_PDQPRIORITY and PDQPRIORITY are percentages. So 100 is all resources, or maximum, or big, or not small.... But the key to parallel index builds is not PDQ but the PSORT package. Set PSORT_NPROCS=<no. CPUs>. Paul was also right about using multiple temp dbspaces. Or Art would probably advocate setting PSORT_DBTEMP to a bunch of directories on different spindles. By all means switch on PDQ for more resources in addition to using PSORT. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+