Brian Beckman shows off a simple hash join in LINQ , using VB9. The performace boosts reinforce some work my partner and I did, experimenting with load-time generated indexes over collections. There was a significant hit incurred when creating the index, but it was assumed that you wouldn't bother unless it actually did any good. The code below is somewhat naive, but shows one approach. In this case, the index tracks several different features of a number, even/odd, positive/negative, and the values
Read More...