Hello,
try to experiment with fq={!cache=false}... or fq={!cache=false cost=100}...
see https://cwiki.apache.org/confluence/display/solr/Common+Query+Parameters
On Wed, Aug 19, 2015 at 8:55 AM, Maulin Rathod <mrat...@asite.com> wrote:
>
> 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]
>
>
--
Sincerely yours
Mikhail Khludnev
Principal Engineer,
Grid Dynamics
<http://www.griddynamics.com>
<mkhlud...@griddynamics.com>
