Just to make myself clearer. I have one memory connection and many stmts. Each stmt multiplexes the thread. This means that a stmt could give up the thread without finalizing itself.
On Wed, Jul 2, 2008 at 11:19 AM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Alex Katebi <[EMAIL PROTECTED]> wrote: > > I have an in memory database and a single multiplexed thread for all > > readers and writes. > > I like to be able to read tables without locking out other readers and > > writers. > > As far as I can tell, you do everything on a single thread using a > single connection. You should never experience any locking at all in > this scenario (but you will experience "dirty reads" with all the > attendant problems). > > Igor Tandetnik > > > > _______________________________________________ > 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
