> Steve, > > Maybe you can tell us about: sure
> - your hardware 2.5GB RAM, pretty modern virtual servers > - query rate Let's say a few queries per second max... < 4 And in general the challenge is to get latency on any given query down to something very low - we don't have to worry about a huge amount of load at the moment. > - document cache and query cache settings <queryResultCache class="solr.LRUCache" size="512" initialSize="512" autowarmCount="256"/> <documentCache class="solr.LRUCache" size="512" initialSize="512" autowarmCount="0"/> > - your current response times This depends on the query. For queries that involve a total record count of < 1 million, we often see < 10ms response times, up to 4-500ms in the worst case. When we do a page one, sorted query on our full record set of 2 million+ records, response times can get up into 2+ seconds. > - any pain points, any slow query patterns Something that can't be emphasized enough is that we can't predict what records people will want. Almost every query is aimed at a different set of records. -Steve