We are using ETL tool Informaica to perform the load. ODBC is required for Informatica to work with MYSQL. We are looking for a solution which will allow us to leverage this tool.
--- In [email protected], "Jim Mullen" <[EMAIL PROTECTED]> wrote: > 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/
