your best bet is to first declare the database without indexes, then load all the data, then add the indexes afterwards.
Indeed.
Just for the kicks, I've tested with 100K records. These are the results:
No indexes: 21 sec. Indexing while inserting: 50 sec. Indexing after inserting: 37 sec.
Okay, I'm glad my idea has worked out here. I would be interested to see what times Edward gets with his 3.7GB of data; I expect those would be a lot more dramatic. -- Darren Duncan
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
