After. I create it after because the total populate-plus-index time is much slower if the index is created before (44 minutes compared to 25).
Thanks, Joel! Any suggestions? Meta-question: this is the second time I've asked this question. The first was about a month ago and got not a single reply. Is there something wrong with my postings? Or is this just not an interesting topic? Many thanks, Stephen On Tue, 2007-03-27 at 11:15 -0400, Joel Cochran wrote: > Did you create the index before or after populating the database? > > -- > Joel Cochran > > > > On 3/27/07, Stephen Toney <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I'm trying to speed up index creation: > > CREATE TABLE keyword (key, contyp int, imagecount int, > searchcat int, > value, nextword, sec, ipr, fldseq int); > CREATE INDEX valuekey on keyword (value, key); > > The value field is a string, max 15 bytes. The key field is a > string of > fixed-width 10 bytes. > > It took only 7 minutes to fill this table with 5.7 million > records, but > it's taking 18 minutes to build the index. This is on a > dual-core Windows > XP Pro machine with 4GB memory. Any ideas on how to improve > this? It will > have to be done as part of a software installation, and I > can't see users > waiting that long. > > By comparison, building separate indexes on the two fields in > the multi- > column index took only 2-3 minutes. Why would it be so much > longer for a > multi-column index? > > > Thanks for any ideas! > -- > > Stephen Toney > Systems Planning > [EMAIL PROTECTED] > http://www.systemsplanning.com > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to > [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to > [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > > > > -- Stephen Toney Systems Planning [EMAIL PROTECTED] http://www.systemsplanning.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
