Re: [sqlite] Queries getting slow with concurrency
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 > issues (no busy handler called). Is there a chance you have network congestion ? Your server can only send out so many bytes per second to its clients and it might have reached the number of bytes its network card can handle. Your operating system should have some tool that tells you how many bytes per second input and output your network card is handling. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Queries getting slow with concurrency
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 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. Regards, Prakash Bande ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users