Andreas,
----- Original Message ----- From: "Andreas Ahlenstorf" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, March 18, 2005 11:47 AM
Subject: Re: Problem: Slow "LOAD FILE" performance with innodb
Heikki Tuuri schrieb:
Creating the indexes after the import will only slow down the operation. MySQL recreates the whole table at CREATE INDEX.
That's new to me, but good to know (always this urban legends...). Does that only apply to InnoDB or to MyISAM too?
I think for MyISAM, the fastest way to load is to 'disable indexes', and 'enable' them again. This is relatively recent. Please consult the manual.
For most other database brands, index creation after the load is the fastest way. That will be true for InnoDB-5.1 also.
Regards, A.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
Order MySQL Network from http://www.mysql.com/network/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
