MySQL The reason it is char(9) fields is because I wrote my own import app (Delphi 6) that writes directly to my "myd" file.
I can import 106 million records from a Fixed Field with text file in 45 Minutes. Then I ran "myisamcheck -r -q experian" to regenerate the indexes. mike... --------------------------------------------------------------------- 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