Hi, We have 1 million of documents and would like to query with multiple fq values.
We have kept the access_control ( multi value field ) which holds information about for which group that document is accessible. Now to get the list of all the documents of an user, we would like to pass multiple fq values ( one for each group user belongs to ) q:somefiled:value& fq:access_control:g1&fq:access_control:g2&fq:access_control:g3&fq:access_control:g4&fq:access_control:g5... Like this, there could be 100 groups for an user. If we fire query with 100 values in the fq, whats the penalty on the performance ? Can we get the result in less than one second for 1 million of documents. Let us know your valuable inputs on this. Regards,