in reply to How to optimized mysql insert into table
Are you running "$dbh->commit;" after every single insert(execute)? Thats where your problem would be. You need to batch up stuff before the commit. try inserting 1000 records then doing the commit.
|
|---|