Subject Re: Massive INSERT test
Author arbitragex <>
--- In, "Alan McDonald" <alan@m...> wrote:
> I did some tests doing this sometime ago... it took longer to add
the index
> at the end of the process than it did to leave it on while the
inserts were
> going.
> I still do it though... spose I hope that the pure logic is true
even though
> my test showed otherwise

I have noticed the same behaviour with other DB as well. Probably re-
reading all the rows to index renders that approach slower. Perhaps
in a locked file situation that might work?