Details
-
Task
-
Resolution: Fixed
-
Major - P3
-
None
Description
Description
Page: https://docs.mongodb.com/manual/reference/operator/query/in/
There can be some performance issues when passing hundreds or thousands of parameters as a $in array. We should note that this is an anti-pattern and may be solved via a schema redesign.
Also, we should recommend that an index exists with the field. In the example here, indexes like {tags: 1} and {qty: 1} would be very beneficial.