Re: [sqlite] Test for pending writes ?
On Wed, Apr 2, 2014 at 5:59 PM, Adrian Soundy < adrian.sou...@integration.co.nz> wrote: > > > Is there a Sqlite method that will tell me if there is any pending writes > from another process so I can end and commit the current transaction > straight away ? > No. Doing that would require some kind of interprocess communication (IPC) and we are not aware of any standard, cross-platform, reliable IPC mechanism that is up to the task. Sorry. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Test for pending writes ?
Hello, I have a process on an embedded device that is continuously updating the database in WAL mode. To get the performance we require in the busy cases we put everything in to transactions. Sometimes another process needs to write to the same database in a timely manner. Is there a Sqlite method that will tell me if there is any pending writes from another process so I can end and commit the current transaction straight away ? Cheers Adrian Soundy ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users