Re: Performance whil Building Indices -- how does it scale?

2002-09-25 Thread Chris Stoughton
Yes, I increased this to 512M, as suggested in another answer, and the perfomance improved dramatically. Thanks for the tip. Jeremy Zawodny wrote: >On Mon, Sep 23, 2002 at 07:25:17AM -0500, Chris Stoughton wrote: > > >>Joseph, >> >>Thanks for the quick answer. >> >>Very nice to know that add

Re: Performance whil Building Indices -- how does it scale?

2002-09-24 Thread Jeremy Zawodny
On Mon, Sep 23, 2002 at 07:25:17AM -0500, Chris Stoughton wrote: > Joseph, > > Thanks for the quick answer. > > Very nice to know that adding an index forces a rebuild of all indices! > (Side note -- I was going to configure the database with a minimal set > of indices, and then watch to see

Re: Performance whil Building Indices -- how does it scale?

2002-09-23 Thread Chris Stoughton
Joseph, Thanks for the quick answer. Very nice to know that adding an index forces a rebuild of all indices! (Side note -- I was going to configure the database with a minimal set of indices, and then watch to see how people use the database, and then add indices on popular columns.) I did