> My question is , if the database is used only for read purpose, > why the header is read everytime as the database connection is not > closed?..can we make it read it only once?
Even though your connection is used only for reading, some other connection (maybe in a different process) can be used for writing. Thus SQLite have to check before each transaction if anything was changed in the database. Pavel On Thu, May 3, 2012 at 1:42 PM, msantha <rssmadha...@gmail.com> wrote: > > I am using sqlite in my application only for read access. 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. > Precisely speaking, 16 bytes from the 24th byte of the header is read > everytime. My question is , if the database is used only for read purpose, > why the header is read everytime as the database connection is not > closed?..can we make it read it only once? > > Thanks!! > > -- > View this message in context: > http://old.nabble.com/SQLITE-Header-access-tp33763427p33763427.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users