I have an app that involves processing tickets in temporal order. There are about 3,000 tickets added each day. To find the next ticket to process, I will do a query on timestamps (i.e. find all tickets with timestamps after the last processed timestamp).
So as tickets are processed, they stay in a collection that stores all the tickets. My question is, should I worry about a collection getting too large (it might eventually have like 100,000 documents)? Will this dramatically effect the performance of my queries? Or should I run something that automatically archives processed tickets that don’t need to be queried anymore?