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 my application (not much I can do except check if 
my busy handler is getting called).

Only other problem I can think of is file system does not like being read 
concurrently, but we use this file system (NTFS network drive) for lot of other 
operations which happen concurrently.


Prakash Bande

sqlite-users mailing list

Reply via email to