LINQ to SQL Beta2 Performance Numbers and the Dynamic Compilation Pattern

Jomo Fisher--Rico Mariani has been posting about LINQ to SQL perfomance and has finally posted the performance numbers for Beta2:

One of the tricks Rico and Matt Warren used to get this stellar performance was to generate IL at run time. I learned this design pattern from Matt and used it on a completely different problem (see to get a 900% performance improvement. I don't know whether this pattern already has a name (Dynamic Compilation seems to fit) but it's hard to ignore its potential for significant performance improvement in a particular class of problem. A further benefit is that you can hide a lot of complex, deep thinking code behind a simple interface that you present to your user.

Correction: Now that I think about it, I may have originally learned this pattern from my high school friend Brandon D'Souza who used it to compile equations into Apple II machine language. This was for a spread sheet application our teacher wanted to call 'Rickards High Scool 1-2-3-4 .'

This posting is provided "AS IS" with no warranties, and confers no rights.