<p>How many elements can <code>array</code> contain in the following query?</p> <pre class="prettyprint"><code>db.collection.find({field: {$in: array}}); </code></pre>

What is the limit on the number of array elements that can be passed to a MongoDB '$in' operator in a query?

How many elements can array contain in the following query?

db.collection.find({field: {$in: array}});

499

asked Mar 10 '12 01:03

Limit for $in(and any query) same as limit for document. Currently it's 16 mbs. Here is related thread Google groups.

137

answered Nov 09 '22 08:11

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!