Re: [sqlite] Multiple threads reading different data

2014-11-11 Thread Hick Gunter
. -Ursprüngliche Nachricht- Von: Daniel Polski [mailto:dan...@agelektronik.se] Gesendet: Dienstag, 11. November 2014 12:59 An: General Discussion of SQLite Database Betreff: [sqlite] Multiple threads reading different data I'm accessing a database from multiple threads, where each thread

Re: [sqlite] Multiple threads reading different data

2014-11-11 Thread Clemens Ladisch
Daniel Polski wrote: > this maybe has to do with me using WAL mode, and that the update is > not yet "processed enough" for the other threads to fetch the new > data (so they still selects the old data), even though the trigger is > set to fire "after update". Is this maybe the case? Yes; other

[sqlite] Multiple threads reading different data

2014-11-11 Thread Daniel Polski
I'm accessing a database from multiple threads, where each thread has a separate database connection. When some specific event happens, I want the threads to evaluate the situation and act accordingly. I have setup a temporary trigger which fires at the event and which in turn calls a