Thanks to everyone who replied - much appreciated. Ok here is how it went : 1 Creating index first and loading table :saved 1 minute overall 2 Increasing key_buffer -> 100M :no difference 3 increasing myisam_max_sort_file_size-> 1000M and myisam_sort_buffer_size->100M :no difference Note that the index concerned is about 80M (table about 300M ) so looks like that is as fast as it goes ( and pre-creating in index helps a little bit ) regards Mark --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php