Re: DBI: speed up insertions in generating database

Make sure to set autocommit off (MySQL's default is on, I believe), and commit not too often (every few hundred rows or so?).

Comment on Re: DBI: speed up insertions in generating database

Replies are listed 'Best First'.
Re^2: DBI: speed up insertions in generating database by Anonymous Monk on Nov 11, 2015 at 17:13 UTC
begin-commit do the magic begin; <some sql code> commit;	[reply]