Re: Parallel index building

Posted in 1999

Obnoxio The Clown — Mon, 04 Oct 1999 13:52:20 BST — source: Informix-list mailing list archive (1991-1998)

From: Thomas Mieslinger <thomas.mieslinger@germanparcel.de> > >I have a large table fragmented in three dbspaces on three disks. When I >do an create unique index then the iostat tells me the DBMS is reading >just from one disk not from three. > >I'm using Solaris 2.6, IDS 7.31UC2 and the following DSS Settings: >MAX_PDQPRIORITY 100 >DS_MAX_QUERIES 64 >DS_MAX_SCANS 64 >DS_TOTAL_MEMORY 256000> >The system is an 4 way PIII 500 Acer Altos with 512MB RAM. > >So how can I speed up the index building? Can it be done parallel? PDQPRIORITY 100 PSORT_NPROCS=2 PDQPRIORITY could be less, and PSORT_NPROCS could be more, but there's a starting point. :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com