On Wed, Jun 20, 2012 at 11:33 PM, Durga D <durga.d...@gmail.com> wrote: > Hi All, > > I have to develop a sqlite application. Within the process, multiple > threads are trying to access in write/read mode. Will sqlite supports read > and write at a time? > > scenario: 1. x number of records (x related data) are going to insert > in a transaction in ThreadA. still, not committed. > 2. In ThreadB (parallel thread), trying to read records > (x related data), which are there in transaction. > > By default, sqlite supports this scenario? or Do I need to enable any > flags/macros?
Yes, SQLite supports that. You can see some "problems" only if ThreadA inserts a lot in one transaction, so that it doesn't fit into memory cache. Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
