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
|
|---|