Pat M. wrote:
I don’t know if this is the good option, but based on the fact that it
wraps each insert in a transaction, you could just start a
transaction, insert all the rows, and then commit. Is that going to
be significantly faster? I’m not sure.
Yup, had the same thought, and after some benchmarking, wrapping the
in a single transaction gives about a %22 speed increase. However, I’m
only (?) getting about 186 rows/sec insert velocity on MySQL/InnoDB.
Also, I’m wondering if this method will work on DBs that don’t support
transactions, i.e. MySQL/MyISAM. Or are we not bothering to support