> Thanks. I understand this. But my file will be on a read-only medium. > So no other connection opening for writing is not possible.
SQLite doesn't know if media is read-only, or is not accessible for writing for current user, or whatever else. So sorry, locks will persist and no speed-up for read-only files. Pavel On Wed, Feb 2, 2011 at 10:36 PM, Navaneeth.K.N <navaneet...@gmail.com> wrote: >> >> You may have opened the file as read-only, but someone else may open the >> same file for writing. Thus, your connection still needs to maintain a >> shared lock, just like any other reader. > > Thanks. I understand this. But my file will be on a read-only medium. > So no other connection opening for writing is not possible. > > -- > -n > _______________________________________________ > 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