RE: Index build speedup -- part2

Posted in 1999

Obnoxio The Clown — Mon, 20 Dec 1999 10:14:32 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Scott Huppert" <shupp@cfer.com> > >I had to rebuild a large index on a 36M row table last night. I set the >PSORT_NPROCS to 10 (2 * NUM_CPUVPS) and PDQPRIORITY to 10. The index build >ran for an hour and a half, then it ran out of temp dbspace! (We currently >run with 6 temp spaces that are 50 Mb each on that box.) I set the >DBSPACETEMP environment variable to a local filesystem and it created >around >300 Mb of flat files and finished in 10 minutes! I was very surprised >since >the temp dbspaces run on a very fast EMC box. Has anyone else seen similar >performance gains by using the local filesystems? You're confirming all my prejudices about RAID... :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com