On Mo, 1999-07-26 05:47:12 -0700, Paul Salaberria wrote:
> I have an indexed table with around 1 million rows. Using LOAD DATA INFILE
> the loading is taking around 30-45 minutes on my present server. The final
> version of the database will have 100 million rows, and needs to be
> re-populated once a week.
> What is the fastest method of populating the table from a .csv file ?
You could drop the indexes before the inserts and the add them again.
This should speed up the inserts quite much, and adding the indexes
later on again should/could be faster than having them updated all the
time during the inserts.
Untested myself ... so I might be wrong.
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7