Select with bound parameters needs transaction

Dec 12, 2014 at 3:27 PM
In the demoworkbook is code that demonstrates parameter binding:
Public Sub TestBinding()

The insert loop is in a transaction, but the select loop is not. Select statements with bound parameters need to be in a transaction as well and this will speed this up enormously.

Dec 29, 2014 at 8:53 AM
Thanks - that's good to note.

I had not realized that with SQLite the selects are also faster in a transaction (due to the file locking that would otherwise happen on every call).