In my application I currently perform a loop inside a recursive function and
sqlite3_bind_* on various fields then call sqlite3_step and a reset inside
my loop but it is fairly slow when inserting, is there a faster way of
inserting inside a loop?
Ie) while(whatever > 0) {
sqlite3_bind_int(stmt,1,iSomething);
sqlite3_bind..
if(sqlite3_step(stmt) == SQLITE_DONE) sqlite3_reset(stmt);
} /// basically something along these lines but with more error checking
and things..
Am I able to perform a transaction where I execute a query with a
begin..insert..end and commit? Would that even be faster?
I just want to make sure I am doing things as fast and efficiently as
possible.
Thanks a lot
- Jon
