12+ hours index.

Posted in 1997

Shannon Sellers — Tue, 2 Dec 1997 21:30:17 -0700 — source: Informix-list mailing list archive (1991-1998)

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