IsNull/ahkDBA — pull request #10 by infogulch (2012-06-06 22:04:18+00:00)
Title: Use prepared queries for DataBaseSQLite.InsertMany

Using prepared queries is faster and more type safe. I tested with
500,000+ row inserts and ran into "Maximum Length Of An SQL Statement"
problems (see: http://www.sqlite.org/limits.html #3). Also using
BeginTransaction, EndTransaction (and Rollback if necessary) along with
prepared queries makes a disk-based db just as fast as :memory: for such
large queries.

The `prepare, loop { bind, step, reset }` method is highly reccomended
vs a giant sql statement by both the docs and developers on irc.