Mike, ODBC is not the most efficient way of accessing a database. If you have phpMyAdmin installed on the MySQL server, use that to load your file into the database. You could also load the file into the database directly from the MySQL command line (if you have access to that).
HTH, Jim at iDimensionz.com http://www.iDimensionz.com - Professional web site design and affordable web site hosting. michaeldegennaro wrote: > Looking for suggestions for inserting millions of rows into mysql. > > Inserts that we are running is loading way too slow (17 rows per > second, whereas we see thousands of rows per second on similar > architecture for Oracle & DB2). > > We are using ODBC to connect to Mysql. > > Thanks. ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
