Hi, our system does fairly predictable queries when it runs. A number
of modules all access data using a handful of queries of each. We open
the database at the start and close it at the end of the program.
Each query follows the usual pattern of prepare - bind - step - reset -
(eventually) finalize.
I was wondering if there is any known drawback in creating statements
up-front when the system is started and use them as and when they are
needed.
1. Do statements do any thing that would require a lot of memory to be
maintained?
2. Are there any known drawbacks of doing this?
3. Finally, if sqlite3_reset is called multiple times before a bind, is
there a problem?
Thanks,
Mohit.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
