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
