LINQ to SQL .Count takes way to much process time and decreases performances.
- by soldieraman
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.