Single Index Solr 4.10.4, optimized Index, 76M docs, 235GB index size. I was analysing my solr logs and it turned out that I have some queries which are above 30 seconds qtime while normally the qtime is below 1 second. Looking closer about the queries it turned out that this is for MatchAllDocsQuery(*:*). Next was to turn debugQuery on and see where the bottleneck is. The result was that the facetting is consuming most of the qtime.
So the question is, are facets or is facetting not cached? Even after sending the query several times in a row I don't get below 35 seconds qtime. Is this normal for a MatchAllDocsQuery(*:*)? My assumption is that the queryResultCache is catching such a MatchAllDocsQuery(*:*). Am I wrong? debug":{ "rawquerystring":"*:*", "querystring":"*:*", "parsedquery":"(+MatchAllDocsQuery(*:*))/no_coord", "parsedquery_toString":"+*:*", "QParser":"ExtendedDismaxQParser", "altquerystring":null, "boost_queries":null, "parsed_boost_queries":[], "boostfuncs":null, ... "timing":{ "time":37429.0, "prepare":{ "time":0.0, "queryfilter":{ "time":0.0}, "query":{ "time":0.0}, "facet":{ "time":0.0}, "mlt":{ "time":0.0}, "highlight":{ "time":0.0}, "stats":{ "time":0.0}, "expand":{ "time":0.0}, "debug":{ "time":0.0}}, "process":{ "time":37429.0, "queryfilter":{ "time":0.0}, "query":{ "time":2310.0}, "facet":{ "time":35117.0}, "mlt":{ "time":0.0}, "highlight":{ "time":0.0}, "stats":{ "time":0.0}, "expand":{ "time":0.0}, "debug":{ "time":2.0}}}}} Regards Bernd