Re: performance issues filtering a query with a long

From: Rhys Campbell <rhys.james.campbell@xxxxxxxxx>
To: mongodb-user <mongodb-user@xxxxxxxxxxxxxxxx>
Date: Tue, 26 Apr 2016 01:19:02 -0700 (PDT)
Why ads?
Couldn't you find the highest contiguous id and say $gt that?

For example. A User has the following list of ids...

1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,27,99,101,110

We could reduce this to...

15,27,99,101,110

Alas SQL We would say

SELECT *
FROM article
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"
group.

For other MongoDB technical support options, see: https://docs.mongodb.org/manual/support/
--- 
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 https://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/63fbd6bf-5df0-4d96-a18c-2985392c8357%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Why ads?