❔ 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
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
