Re: 12+ hours index.

Shannon Sellers (ssseller@concentric.net) wrote: : We have a system with 54 million records. Building an index takes over 12 : hours. Is this an acceptable time or do we have a problem? it seems extreme : to me! : The system is a 4 pentium pro running AT&T unix with I believe 128 meg of : ram and something like 72 Gig of harddrives. : I don't work on this system, but wondered if it should really take that : long. : Thanks Shannon A few things to look at: Look at your DBTEMPSPACE. Make sure you are using temp spaces in the database and not in the /tmp directory How's your parallelism set up? Are you using the multiple processors? Look at PSORT_NPROCS. I'd set it at 4. I've run an index against 700,000,000 rows on an HP 7-processor system and had it take about 7-8 hours. -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" Slaving away on "INFORMIX DEBUGGERS Survival Guide", available early 1998 from Prentice Hall/Informix Press. If you have debugging tips, tools, or ideas to share, please send me some e-mail. ---------------------------------------------------------------------------