In a .NET Core web app when handling large amounts of data calculated from multiple tables in order to calculate lots of consistent metrics in the form of reports, I’m looking to learn more about design choices that can be made to improve the overall performance of calculating these values. I understand this might be a bit vague but please bear with me.