On Tue, 9 Mar 1999, Jason Slagle wrote:
> What, if anything, are you using as an index.
>
> I have 1,400,000 entries (200MB) I'm inserting into a database. Radius
> detail files as a matter of fact. Apart from COPY taking forever to load
> that (probably due to my several indexes), it seems the select is VERY
> slow. Any tips?
I found that if you create an index before doing a bulk COPY, yes, it does
take forever to load, and the select is slow. What I did was drop the
indices built from the COPY and rebuild them. Speeded the selects up
significantly. So now I don't build any indices until after I load my
huge databases in.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
That's what she said.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N+ o K- w--- O@ M@ !V PS+++
PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ G++ e>++ h+(---) r++ y++++
------END GEEK CODE BLOCK------