Re: (2) Poor Performance with 7.31.uc6

From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > >Obnoxio The Clown wrote: > > > > A word to the wise: when you need to do your index rebuilds, set the > > following environment variables: > > > > PSORT_NPROCS=[2 * NUMCPUVPS] > > PDQPRIORITY=100 > > PSORT_DBTEMP=/tmp1:/tmp2:/tmp3 # i.e., 3 temporary filesystems > > > > You will be mildly impressed by the index build speed. I've been fooling > > about with a 100M row table, and it builds a single-column index in < 20 > > minutes. On a 2-way HP box. > >Don't limit yourself to 2x. It really depends on CPU speed and disk >speed / number. Also fragment the table and or index if you can. Some of us are working on weenie HP boxes, remember. :-) I think fragmenting the table is more important than fragmenting the index. But that's just me. :) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com