For the performance related things, you need to consider below points:
1. Whether the performance is slow for the overall application.
2. Is the performance degradation from the database side?
3. is the application UI performance is slow?
Once you analyze these points, you will come-up with the way through which you can improve the performance:- If the performance is degrading from the database, then you need to check at which point the response from the database is slow? There could be some View, Stored Procedure, select query with multiple joins, Indexes etc.
If the performance is degrading from the UI, you need to check whether there is the problem with the multiple Ajax calls, any other UI component is making the performance slow etc.
The overall application performance could be low in the bandwidth which can also cause the performance degradation issue,
Hope it will be helpful to you.
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)