Re: [PERFORM] How to keep queries low latency as concurrency increases

2012-11-25 Thread Catalin Iacob
nd but our 9000 queries/second to seem push it too much. The longer term solution for us would probably be to do less connections (by doing less Django requests for a page) and less queries, before our deadline we were just searching for a short term solution to handle an expected traffic spike.

[PERFORM] How to keep queries low latency as concurrency increases

2012-10-29 Thread Catalin Iacob
As I increase concurrency I'm experiencing what I believe are too slow queries given the minuscule amount of data in my tables. I have 20 Django worker processes and use ab to generate 3000 requests to a particular URL which is doing some read only queries. I ran this with ab concurrency level set