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

Reply via email to