Re^3: How to optimise " csv into mysql " using TEXT:CSV

Thanx for the hint, indeed switching AutoCOmmit off increased the speed by roughly 30%.

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

Replies are listed 'Best First'.
Re^4: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql by SimonPratt (Friar) on Aug 06, 2015 at 14:55 UTC
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	[reply]

Replies are listed 'Best First'.

Re^4: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql
by SimonPratt (Friar) on Aug 06, 2015 at 14:55 UTC

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

[reply]