>>>>> "Martin" == Martin Ramsch <m.ramsch@stripped> writes:
Martin> 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 ?
Martin> You could drop the indexes before the inserts and the add them again.
Martin> This should speed up the inserts quite much, and adding the indexes
Martin> later on again should/could be faster than having them updated all the
Martin> time during the inserts.
Martin> Untested myself ... so I might be wrong.
You are right; This is described in the MySQL manual!
Regards,
Monty

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.