C#•2mo ago

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)

2 Replies

Angius•2mo ago

Try .AsSplitQuery() Though... it's weied, not like you'd be running into carthesian explosion See what query is produced, too

hosteripOP•2mo 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

Gaming

Programming

Two properties slows down the query for 26 seconds