LINQ Scalability

Linq , or Language Integrated Query is a type of in memory query language built into Dot Net.

We have found this approach often works well for smaller type data sets. With larger datasets the object type approach slows down since more memory is used. Also a lot more ‘back and forth’ between RAM and CPU is required.

Internally our technology uses simple datatypes and arrays for storing data and for executing  queries. Whereas Linq can work well up to about a million records, our approach allows you to aggregate over hundreds of millions of records in under a second in a Dot Net Environment.