On 11/28/2011 12:21 PM, Alejandro Martínez wrote:
The reader processes create all the papared statements at startup, so
they would be parsed only once.
then, whenever they need to read from the db, they just reset, bind
and step the prepared statements i already had.
Do it in a different order - bind, step through to the end, then reset
immediately. Don't keep active statements around for a long time - this
keeps read transaction open.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
