data loding time is more in LINQ with mvc C#

Kalyani Shevale

H has used LINQ in C# with MVC. In Database monthly, 30000 records inserted .when this get that time loading time is more required how to overcome this loading time.

I have used 2 types of loading data method,

1) I have loaded all data in Global.asax file then access that time 1st time loading time is more but after project loading ...time is less required.

2)I have direct call get method in each n every time that time more time required getting data .how to overcome this time in LINQ using in c# MVC.

if any other solution then tells me in this methos any changes required...

I have Attached Global.asax n Normal View Data when list display.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews7y ago
Performance issues shuld be fixed after proper analysis and so no readymade answers to take. You use a tool to identify which layer or coding part is causing issues. Then target those areas. Manual analysis only helps if code base is very small.
Kalyani Shevale7y ago
Hi jaish

if you have any other Solution for this...which method we will use for getting Performance??
Jaish Mathews7y ago
This is not an answer, but to correct the statment "overcome this time in LINQ using in c#". LINQ for easy and readability code, not for getting performance.