Re: [sqlite] fetching rows

No, SQLite doesn't do auto-commits every 25k insertions. It does auto-commit after each INSERT statement (no matter how many rows it inserts). If you wrap several INSERT statements into transaction it will execute faster. Pavel On Sat, Jun 23, 2012 at 3:13 PM, Durga D

Re: [sqlite] fetching rows

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 wrote: > On Wed, Jun 20, 2012 at 11:33 PM, Durga D

Re: [sqlite] fetching rows

On Wed, Jun 20, 2012 at 11:33 PM, Durga D 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

[sqlite] fetching rows

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