Pavel, So does it mean that in SQlite there is no way to stop the read operation while a write operation is running, like table level exclusive lock.
Thanks Harnek -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: May-02-12 4:26 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQlite exclusive table lock > I can't use WAL because it doesn't stop readers from reading. For this sort of synchronization you should use OS synchronization primitives, especially if you want to do that among different processes. Pavel On Wed, May 2, 2012 at 5:11 PM, Harnek Manj <hm...@gemcomsoftware.com> wrote: > Hi, > > Should I use Shared-Cache in sqlite to have the exclusive table lock, so that > readers have to wait for the write operation to finish. I don't want the > complete database file locked while there is write operation. I can't use WAL > because it doesn't stop readers from reading. > > Thanks > Harnek > _______________________________________________ > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users