-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 30/12/13 06:18, Igor Tandetnik wrote: > sqlite3_clear_binding is very rarely needed, in my experience. In fact, > I have not yet encountered a reason to use it.
I use it in my Python wrapper (APSW). The reason is because I have an automatic statement cache. The bindings are cleared before being putting the statement into the cache to free up any memory (they could have large blobs or strings) and to make the state of the statement being taken out of the cache match that of the same one freshly prepared exactly. I am of the opinion that SQLite should have a statement cache built in rather than everyone having to implement their own: https://www.sqlite.org/src/tktview?name=ee4b2b48f5 Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.14 (GNU/Linux) iEYEARECAAYFAlLB3aYACgkQmOOfHg372QSsFgCgwLkmzGqOrVL9YRLy6gG1E/cC W+4An1ZFo5njgI0V3i6IAVMrubdGMdQv =Linf -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users