Thanks Pavel,
That gives me something new to do with SQLite over the next few weeks.
On 23/4/2012 8:47 PM, Pavel Ivanov wrote:
1. Do statements do any thing that would require a lot of memory to be
maintained?
No, they don't need a lot of memory, but still some memory is used. So
if you have like thousands of statements you should worry about this.
If you have 20 or 30 statements your database cache will likely
consume much more memory, so don't worry.
2. Are there any known drawbacks of doing this?
Preparing all statements takes some time which adds to startup time of
your application. Also you could prepare some statements which won't
be used later. If those are not problems for you then preparing all
statements at startup is a way to go.
3. Finally, if sqlite3_reset is called multiple times before a bind, is
there a problem?
No, there's no problem in here.
Pavel
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
