Our applications all use sql server databases and some of our cores tables are starting to get rather large, millions of rows... We have set up a replicated SQL Server that we use for reporting and queries and other data needs outside the main applications. However, I’m already starting to notice some functionality slowing down because of the volume of data. I still want the customers to be able to access the historical data, kind of like how you can view history in Reddit, but I feel like having all the history in the original tables and schema might not be a good long term solution. I have seen lots of tutorials on how to build CRUD applications but a not so much on what to do when things really scale... If anyone has any good articles or tutorials about this, please share them.