Re: HPL Deluxe Mode
Posted in 2000
"Martin, Wayne E." wrote:
>
> Set PSORT_NPROC = number of cpuvp's
Set this much higher, but make sure you have lots of virtual memory. I
once brought a box to it's knees when we eventually reached a value that
used all memory. We then had to watch while the machine swapped out 1 Gb
of database memory. It was NOT a pretty sight! :-)
> SET PSORT_DBTEMP = fast disk and empty directory can use multiple separator
> is ":"
> Set PDQPRIORITY = 1;
Set this to 100, unless you are trying to do other things at the same
time. If you are, delay them until after the index build. ;-)
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /|
| http://www.informix.com http://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |This email will self-destruct in |/// / ////|
| |10 sec. If you received this email |// / /////|
| |in error, sorry about the mess. |/ ////////|
+----------------------+-----------------------------------+-----------+