C
C#•6mo ago
hosterip

Two properties slows down the query for 26 seconds

so the problem is in the middleName and lastName properties, the thing is if I in any way mention them in the query, then it is slows down the request for 25-30 seconds, tried everything and only initializing the properties later is helpful (showed on second screenshot)
No description
No description
2 Replies
Angius
Angius•6mo ago
Try .AsSplitQuery() Though... it's weied, not like you'd be running into carthesian explosion See what query is produced, too
hosterip
hosteripOP•6mo ago
maybe would have worked, but with paginating it is problem, it says that I cant use the skip method, and forces to use AsSingleQuery

Did you find this page helpful?