Do I need to enable shared cache mode plus read uncommitted option? Also you mentioned earlier: "(but you will experience "dirty reads" with all the attendant problems)."
What is a dirty read? What problems does it cause? Thanks, -Alex On Wed, Jul 2, 2008 at 2:55 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Alex Katebi <[EMAIL PROTECTED]> wrote: > > 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. > > That's OK. It used to be that, say, a SELECT statement in progress (not > yet finalized or reset) would block an UPDATE statement on the same > connection. This has not been the case for a long time now. Just use a > reasonlably recent version of SQLite. > > 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
