Re: [sqlite] Test for pending writes ?

2014-04-02 Thread Richard Hipp
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 ?

2014-04-02 Thread Adrian Soundy
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