At 12M documents, operating system cache can be significant. Also, the first time you sort or facet on a field, a field cache instance is populated which can take a lot of time. You can prevent slow first queries by configuring a static warming query in solrconfig.xml that includes the common sorts and facets.
-Yonik http://www.lucidimagination.com On Thu, Sep 10, 2009 at 8:55 PM, Jonathan Ariel <ionat...@gmail.com> wrote: > Hi!Why would it take for the first query that I execute almost 60 seconds to > run and after that no more than 50ms? I disabled all my caching to check if > it is the reason for the subsequent fast responses, but the same happens. > I'm using solr 1.3. > Something really strange is that it doesn't happen with all the queries. It > is happening with a query that filters some integer and string fields joined > by an AND operator. Something like A:1 AND B:2 AND (C:3 AND D:"CA") (exact > match). > My index is around 12000000M documents. > > Thanks, > > Jonathan >
