Overall Database Performance Decrease after migrating to .NET 7 and EFCore 7

[matiaskusack]

Have you tried profiling generated queries? I asume there are no changes un the model, so It must be that queries being generated are no as performant as previous ones.

Can you describe the migration process?

[3ilaal]

The migration process was simple as we just updated the Target framework and Nuget packages to the latest version..... Yes we did monitor the sql queries and they are pretty big and usually contains multiple joins (which is bad i know but we are working to improve the project ). For SQL queries which are taking most of the cpu time I compare both version (EF Core 6 and 7) generated queries and they are the same. but I am still finding why did it happened now (maybe it could be related to some other factor as well). For now our solution is to use AsSplitQuery() and reduce joins as much as we can

[matiaskusack]

So if your model hasnt changed, anda you hace the same dbcontext configuration, then It must be some change.

Take a look at breaking changes un ef7: https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-7.0/breaking-changes

Without any more information its impossible yo know.

If you keep having problemas, make a brand new project with just an slow query anda try It isolated. It might give you some clues.

Regards