LINQ to SQL .Count takes way to much process time and decreases performances.
Posted
by soldieraman
on Stack Overflow
See other posts from Stack Overflow
or by soldieraman
Published on 2010-05-02T16:52:04Z
Indexed on
2010/05/02
16:58 UTC
Read the original article
Hit count: 194
LINQ to SQL .Count takes way to much process time and decreases performances.
I am doing a recursive loop and for one child (lets call it parent) I have to check the number of children under it to make a decision if it should be included or not.
The Count is too slow 8 ms :( for 120 parent records.
Any ideas to make it quicker.
© Stack Overflow or respective owner