Re: [sqlite] Queries getting slow with concurrency

2010-11-25 Thread Simon Slavin
On 25 Nov 2010, at 10:15pm, Prakash Reddy Bande wrote: > I have observed that when multiple processes from "different" hosts are > concurrently doing the queries, the performance of sqlite degrades > considerably. > Queries are read only hence I believe that there should not be any locking >

[sqlite] Queries getting slow with concurrency

2010-11-25 Thread Prakash Reddy Bande
Hi, I have observed that when multiple processes from "different" hosts are concurrently doing the queries, the performance of sqlite degrades considerably. Queries are read only hence I believe that there should not be any locking issues (no busy handler called). I will dig a little more in