Hi I am using solr 4.2.1.
My index has products from different stores with different attributes. If i want to get the count of all products which belongs to store X which is coloured red and is in-stock… My question is : Which way of querying is better in-terms of "performance" and "cache usage". 1) q=*.*&fq=(store:X) AND (colour:red) AND (in-stock:true) 2) q=store:X&fq=(colour:red) AND (in-stock:true) 3) q=store:X&fq=colour:red&fq:in-stock:true f there is any other option better than these three.. please add let me know.. i am assuming that which ever filter eliminates more products… should come first (q, then list of fq's) ./zahoor