On Sat, Mar 7, 2009 at 1:42 AM, Brian Knoth <bkn...@myperfectgig.com> wrote:
> Thanks for your comment. Yes, it would be simple if it was just 3 queries, > I really have about 50-60 I'd like to consolidate as a single request. I'm > simply getting a count of records for each query, and right now, it takes > about 40mS for each request as a single query, but multiplied by about 50 or > 60, brings me up into the 1.5/2.0 second response time (to handle them all) > Perhaps if you tell us more about what you are trying to do, we can suggest an alternative? What do those queries (for which you need count) look like? Are you familiar with faceting? Looks like facet.field or facet.query may be helpful here. The 40ms for a single query may not be the overhead of an http request (that is more like 2-5ms) and even if you executed all of them through one http request, they may still take approximately the same amount of time. -- Regards, Shalin Shekhar Mangar.