On 5/3/2012 1:42 PM, msantha wrote:
I am using sqlite in my application only for read access.
But someone else might open and modify the same database. You may know this doesn't happen, but SQLite doesn't.
The DB gets hit often by my application and I could see that the header(100 bytes) of the database is read every time when i access the database.
Most likely, checking the schema cookie, to confirm that the database schema remains unchanged and prepared statements are still valid.
can we make it read it only once?
Try starting a transaction at the beginning, and keeping it open the whole time the application runs.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
