Re: &fq degrades qtime in a 20million doc collection

[Anria B.]

Here are some Actual examples, if it helps

wt=json&q=*:*&indent=on&fq=SolrDocumentType:"invalidValue"&fl=timestamp&rows=0&start=0&debug=timing

{
    "responseHeader": {
        "status": 0,
        "QTime": 590,
        "params": {
            "q": "*:*",
            "debug": "timing",
            "indent": "on",
            "fl": "timestamp",
            "start": "0",
            "fq": "SolrDocumentType:\"invalidValue\"",
            "rows": "0",
            "wt": "json"
        }
    },
    "response": {
        "numFound": 22916435,
        "start": 0,
        "docs": []
    },
    "debug": {
        "timing": {
            "time": 590,
            "prepare": {
                "time": 0,
                "query": {
                    "time": 0
                },
                "facet": {
                    "time": 0
                },
                "mlt": {
                    "time": 0
                },
                "highlight": {
                    "time": 0
                },
                "stats": {
                    "time": 0
                },
                "debug": {
                    "time": 0
                }
            },
            "process": {
                "time": 590,
                "query": {
                    "time": 590
                },
                "facet": {
                    "time": 0
                },
                "mlt": {
                    "time": 0
                },
                "highlight": {
                    "time": 0
                },
                "stats": {
                    "time": 0
                },
                "debug": {
                    "time": 0
                }
            }
        }
    }
}

Now we wipe out all caches, and put the filter in q.

wt=json&q=SolrDocumentType:"invalidValue"&indent=on&fl=timestamp&rows=0&start=0&debug=timing
{
    "responseHeader": {
        "status": 0,
        "QTime": 266,
        "params": {
            "q": "SolrDocumentType:\"invalidValue\"",
            "debug": "timing",
            "indent": "on",
            "fl": "timestamp",
            "start": "0",
            "rows": "0",
            "wt": "json"
        }
    },
    "response": {
        "numFound": 22916435,
        "start": 0,
        "docs": []
    },
    "debug": {
        "timing": {
            "time": 266,
            "prepare": {
                "time": 0,
                "query": {
                    "time": 0
                },
                "facet": {
                    "time": 0
                },
                "mlt": {
                    "time": 0
                },
                "highlight": {
                    "time": 0
                },
                "stats": {
                    "time": 0
                },
                "debug": {
                    "time": 0
                }
            },
            "process": {
                "time": 266,
                "query": {
                    "time": 266
                },
                "facet": {
                    "time": 0
                },
                "mlt": {
                    "time": 0
                },
                "highlight": {
                    "time": 0
                },
                "stats": {
                    "time": 0
                },
                "debug": {
                    "time": 0
                }
            }
        }
    }
}



--
View this message in context: 
http://lucene.472066.n3.nabble.com/fq-degrades-qtime-in-a-20million-doc-collection-tp4250567p4250823.html
Sent from the Solr - User mailing list archive at Nabble.com.