Hi Michael/Igor, So, I can establish x connections in app initialize time in WAL mode. Based on request (read or write), I can pick the connection and serve. Allows only one write at a time.
Is it correct? Thanks in advance. Regards, On Mon, Jul 16, 2012 at 4:43 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Black, Michael (IS) <michael.bla...@ngc.com> wrote: > > Ummm....are we forgetting about WAL mode? > > > > http://www.sqlite.org/draft/wal.html > > > > "Reading and writing can proceed concurrently." > > > > Not that you can have multiples of each...just one of each. > > To be precise, with WAL you can have one writer and multiple readers at > any point in time. Without WAL, it's one writer OR multiple readers. > -- > 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