My courier company handles over 3,000 orders per month. The courier’s application constantly searches for active and inactive orders out of all 3,000 rows. If my order category has 3,000 rows, will the application slow down significantly? Is 3000 a small number? Now I have 250 rows and everything is ok.
3,000 is no issue for bubble.
Slower? Maybe ever so slightly, but probably in the range of 10-40 milliseconds.
Yeah 3k is small.
I would suggest instead of constantly running searches, use database triggers for this use case.