I have a collection of documents which are readings from a group of sensors. The documents have the date of the reading, the reading itself, and the id of the sensor.
I need to be able to return some of these documents in a date range in order to graph them in a user facing program. I know how to get documents in a date range, but if the range is big enough there could be a lot of documents returned, let's say 1000. Limiting the returned documents to, say 100, would only return the first or last 100 documents. Is there any way to return the documents spread across the date range?
I don't want to randomly select documents up to the limit, because that would make the graph inconsistent for each request.