Performance Issue with EF Core 8.0 and Microsoft.EntityFrameworkCore.DynamicLinq Package

[codepassion86]

1. Description

Hello @StefH

I am reaching out to you to report a performance issue encountered with version 8.0 of EF Core, specifically concerning the "Microsoft.EntityFrameworkCore.DynamicLinq ver. 8.3.10" package.

We have observed significant slowdowns (over a minute of waiting) when executing an order by on any query, even when dealing with a minimal number of results (even with just one record). This slowdown occurs only during the initial execution.

We would appreciate any guidance on how to resolve this issue or if there are any updates or alternative solutions available to improve the performance of this package.

Thank you in advance for your attention and assistance regarding this matter.

Best regards.

[StefH]

Related #781

[codepassion86]

Ok, but with the .NET 6.0 version this problem did not appear

[StefH]

I did create an example project which uses MS SQL. And tested 6 and 8, not much difference:

(The first query is indeed slower)

.NET 6 (Release mode)

Elapsed time: 1393,0677ms
1, Star Wars Episode IV: A New Hope, 1979, 10
2, Ghostbusters, 1984, 5,5
3, Terminator, 1984, 8,5
4, Taxi Driver, 1976, 5
8, Analyze This, 1999, 10,5
9, Leon: the Professional, 1994, 8,5
10, Mission Impossible, 1996, 8,5
--------------------------------------------------------------------------------
Elapsed time: 4,9237ms
1, Star Wars Episode IV: A New Hope, 1979, 10
2, Ghostbusters, 1984, 5,5
3, Terminator, 1984, 8,5
4, Taxi Driver, 1976, 5
8, Analyze This, 1999, 10,5
9, Leon: the Professional, 1994, 8,5
10, Mission Impossible, 1996, 8,5

.NET 8 (Release mode)

Elapsed time: 1063,9211ms
1, Star Wars Episode IV: A New Hope, 1979, 10
2, Ghostbusters, 1984, 5,5
3, Terminator, 1984, 8,5
4, Taxi Driver, 1976, 5
8, Analyze This, 1999, 10,5
9, Leon: the Professional, 1994, 8,5
10, Mission Impossible, 1996, 8,5
--------------------------------------------------------------------------------
Elapsed time: 5,7117ms
1, Star Wars Episode IV: A New Hope, 1979, 10
2, Ghostbusters, 1984, 5,5
3, Terminator, 1984, 8,5
4, Taxi Driver, 1976, 5
8, Analyze This, 1999, 10,5
9, Leon: the Professional, 1994, 8,5
10, Mission Impossible, 1996, 8,5

See this PR for details
#785

[StefH]

@codepassion86
The default implementation from the DefaultDynamicLinqCustomTypeProvider.cs is to load all assemblies to search for DynamicLinq types. In case your solution does include a lot of dependencies/assemblies, all these need to be scanned.

In order to limit this, you can build your own provider which implements IDynamicLinqCustomTypeProvider.cs where you only load the assemblies which are required for your application.

[codepassion86]

@StefH
thx for the suggestion. I will try to do as you wrote.

[StefH]

@codepassion86
Did you have time yet to validate this?

[codepassion86]

@StefH
No, I haven't tried what you suggested because I've changed my approach.

[StefH]

Closing this in favor of #790