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.

  • Comment on Re: How to optimized mysql insert into table