In looking at the SQLite C++ Wrapper (http://dev.int64.org/sqlite.html) I noticed the example insert code has a loop like:
for(int i=0; i<10000; i++) { cmd.bind(1, i); cmd.executenonquery(); } but sqlite3_reset() isn't being called each time after the statement is executed (executenonquery() just ends up calling sqlite3_step() ). Doesn't sqlite3_reset() have to be called in order to reuse a prepared query? -Dave