❔ Memory and performance on big queries LINQ & EF Core
Hi guys, I have a question, I need to make big queries to the db for pagination, however every single request takes a lot of time and I am not sure if for such case it is better to create stored procedure or is there anything else I can do to improve the queries.
Do you guys have some workaround for this?
Here is the gist https://gist.github.com/HeyBaldur/ca9d98ca61c8dffae60c0e72171bfb51
We are also talking about the amount of records are more than 5000
2 Replies
@HeyBaldur https://learn.microsoft.com/en-us/ef/core/querying/pagination
they've got an excellent guide on how to efficiently use pagination with ef in the docs
Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.