Hi All,
I have read one of the performance document and it stated that "prepared
statements must be generated inside transaction". Is that correct.
The document also stated that " While trying to improve the performance of bulk
imports in our C++ project, we found that creating the prepared statements was
a large hit. Creating them once at the
construction of our class, though, made the problem worse! It turns out
that prepared statements that are generated before the transaction start do not
work with the transaction. The fix was simply to
create new prepared statements once per transaction."
So I have to do this:
begin transaction
prepared statement
..............
end transaction.
I though the prepare statement must be outside of the transaction. Can any one
confirm this?
Thanks,
JP
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
