Large Hierarchical result sets are slow to parse

abe545 / CodeOnlyStoredProcedures

A library for easily calling Stored Procedures in .NET using only code (no xml or gui).

MIT License

4 stars 3 forks source link

Large Hierarchical result sets are slow to parse #77

Closed abe545 closed 8 years ago

abe545 commented 8 years ago

This is because linq is used naively to create the hierarchies. With large sets, this gets incredibly slow. The child collection should definitely be accessed by doing a ToLookup first, and then getting the children by id.