Thank you(Pavel) for the prompt response. Sqlite does auto commit for every 25k insertions. Do I need to change the number from 25k to x ( for ex: 100)?
On Thu, Jun 21, 2012 at 7:54 AM, Pavel Ivanov <paiva...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
