On 11/11/2011 7:24 PM, Matt Young wrote:
Embedded Sqlite3 questions:
I want to load and prepare multiple statements, keep them prepared and when
I want to use one of them, I will reset,  bind and step.

Make it bind, step and reset. Don't leave a statement active for a long time - it keeps the transaction open.

Can pre-prepare multiple independent statements, then run them one at a
time at random?

Yes.
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to