[mongodb-user] Re: performance issues filtering a query with a long
Re: performance issues filtering a query with a long
Rhys Campbell <
Tue, 26 Apr 2016 01:19:02 -0700 (PDT)
Couldn't you find the highest contiguous id and say $gt that?
For example. A User has the following list of ids...
We could reduce this to...
Alas SQL We would say
WHERE id >= 15
AND id NOT IN (27,99,101,110)
I'd also consider putting a datetime restriction or perhaps just the last
10K articles as well.
You received this message because you are subscribed to the Google Groups "mongodb-user"
For other MongoDB technical support options, see:
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user+unsubscribe@xxxxxxxxxxxxxxxx.
To post to this group, send email to mongodb-user@xxxxxxxxxxxxxxxx.
Visit this group at
To view this discussion on the web visit
For more options, visit
for more updates.