Hi, http://stackoverflow.com/questions/11627427/solr-query-q-or-filter-query-fq
As per above link it suggests to use Filter Query but we observed Filter Query is slower than Normal Query in our case. Are we doing something wrong? SLOW WITH FILTER QUERY (takes more than 1 second) ============================================ q=+recipient_id:(4042) AND project_id:(332) AND resource_id:(13332247 13332245 13332243 13332241 13332239) AND entity_type:(2) AND -action_id:(20 32) ==> This returns 5 records fq=+action_status:(0) AND is_active:(true) ==> This Filter Query returns 9432252 records Final result is 0 records. FAST WITHOUT FILTER QUERY (takes less than 10 millisecond) ============================================== q=+recipient_id:( 4042) AND project_id:( 332) AND resource_id:(13332247 13332245 13332243 13332241 13332239) AND entity_type:(2) AND -action_id:(20 32) AND +action_status:(0) AND is_active:(true)==> This returns 0 records Final result is 0 records. Regards, Maulin [CC Award Winners 2014]
