in reply to Re^3: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql
in thread How to optimise " csv into mysql " using Text:CSV_XS and DBD::Mysql

No worries :-)

I would also suggest you look into that finish call. It seems odd to be calling it immediately after executing the statement each time. A more expected workflow would be to prepare a statement, execute it multiple times, finish the statement, commit (or rollback) changes to the DB, then disconnect

I use DBI here, but only for Microsoft SQL Server and have never used the finish command, so not really sure what it does

  • Comment on Re^4: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql