On 2/2/2011 9:19 PM, Navaneeth.K.N wrote: > I have an application that uses SQLite just for querying. Application > will not write anything to the database. So I am wondering will I get > a better query time if the database is opened with flag > SQLITE_OPEN_READONLY? I am guessing on a read only database, SQLite > doesn't have to do any kind of locking which will lead to performance > improvement.
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. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
