Hi,
I am retrieving ids from collection1 based on some query and passing those ids as a query to collection2 so the query to collection2 which contains ids in it takes much more time compare to normal query. Que. 1 - While passing ids to query why it takes more time compare to normal query however we are narrowing the criteria by passing ids? e.g. query-1: doc_id:(111 222 333 444 ...) AND <other criteria> slower (passing 80k ids takes 7-9 sec) than query-2: only <other criteria> (700-800 ms). Both returns 250 records with same set of fields. Que. 2 - Any idea on how i can achieve above (get ids from one collection and pass those ids to other one) in efficient manner or any other way to get data from one collection based on response of other collection? Thanks & Regards, Bhaumik Joshi
