Does anybody know how to improve ef core performance? I

Question

C#

Eduardo

Does anybody know how to improve ef core performance? I

have so many .Include and .ThenInclude.. Is there some alternative?

0

29.07.2021

3 ответов

11 просмотров

david

Дима Тимченко
You should use AsNoTracking() if your query for re...

wow this led me to look into anonymous types, I had no idea I could do this

0

29.07.2021

Дима Тимченко

And also check how your query is translated into sql. There're some tricky things, sometimes this behaviour is implicit. It's possible that part of your data (for example, filtering) processed on the server

0

29.07.2021

Дима Тимченко · Accepted Answer

Дима Тимченко

You should use AsNoTracking() if your query for read purposes. Also you can specify anonymous object to select only required properties. Your tables should have indexes on foreign keys. It's basic advice, if you share the query maybe someone will help you more

0

29.07.2021

Похожие чаты

Does anybody know how to improve ef core performance? I

3 ответов

Похожие вопросы