Well, My hat's off to MySql 4 I finally got around my slow query problem... :-)
Mysql has beat any other database I have used for this specific purpose... I wrote a quick little app to directly import records to the MYD file. I then run "myisamchk -r -q v:\Data\...\..\MyDataFile" to reindex the MYI file... I can Import 120 million records in 35 minutes. And reindex them in 40 minutes!! Good Job MySQL Programmers... Mike Grover --------------------------------------------------------------------- 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