What is my best option with my product table having 27,000 rows and increasing by 100+ daily. Where 90% of it has been sold, in which case we have a field (column) for archiving. For a salespeople, we easily run a security filter to keep all archived products from syncing to their app. However on management side, we often need to look back at some archived items related to some recent orders to resolve issues (ex: exchanges, repairs, warranties). What can I do, as it causes crashes everyday at this point.
I currently have my orders table filtered to only go back 30 days on orders. So references like order details with my products, deliveries, rendered payments, all these tables relate.
And it’s just crashing and resetting while users are trying to upload new inventory or such.
How can I resolve this?