Hi all! I'm trying to measure the query response time when using just a query and when using some filter queries. From what I read and understand adding filter query should boost the query response time. I used luke to understand over which fields I should use filter query (those that have few unique terms, in my case 2 fields of 30 and 400 unique fields). I'm using solr 1.3. In order to test the query performance I disabled queryCache and documentCache, so I just have filterCache enabled.I did that because I wanted to be sure that there is no caching when I measure my queries. I left filterCache because it makes sense since filter query uses that.
When I first execute my query without filter cache it runs in 400ms, next execution of the same query around 20ms. When I first execute my query with filter cache it runs in 500ms, next execution of the same query around 50ms. Why the query with filter query runs slower than the query without filter query? Shouldn't it be the other way around? My index is around 12M documents. My filterCache max size is set to 40000 (I think more than enough). The fields that I use as filter queries are integer and in my query I search over a tokenized text field. What do you think? Thanks a lot, Jonathan
