First call to backend (WebAPi) is really slow-CodePudding

I have a simple web api using .Net framework 4.5 and Entity Framework.
The problem is the first call to the backend (WebAPI) is really slow.
I had found a workaround

Does anyone have another solution or idea's? Thanks a lot.

CodePudding user response：

My suggestion is used caching for same type of data used in whole application which will reduce time of execution and in your problem statement there might be issue with shutting down of server when there is inactivity of request...

CodePudding user response：

you can use Lazy load for performance for next time loading you can use caching for example if you use stored procedure you can use
```
OFFSET @skip ROWS FETCH NEXT @PageCount ROWS ONLY
```