Hi I have a table with about 20m rows. It is a MyISAM table. I do a alter table disable keys before loading with "LOAD DATA". Re-creating the primary key after import takes a long time. I have increased the myISAM sort buffer to 75MB and the Key buffer is 100MB.
Is there anything else I can do to improve the performance of index creation ? Thanks Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
