c# - ADO. Net Fetching Data for Summary Dashboard

Question

I have created this ASP. Net MVC Dashboard Page for Quick Summary Reports for the Users upon login.

These Quick Reports consist of Record Counts usually grouped by some important fields which is fetched from Relational Tables (3 Tables) with large data.

I would like to seek your help or tips on how should I handle these large amount of data that (From Relational Tables) will produce summary reports without compromising the speed and performance of my Dashboard Page.

Current Solution (Affects Performance)

• Im fetching hundreds/thousands of data related to user then manipulates the data by using Lamba Expression (Group By) to get the Record Count for the summary.

Answer 1

等待大神答复