So, I recently blogged about the huge penalty for not compiling your LINQ2SQL. This problem is so big that it occurred to us that maybe all of LINQ has the problem. So, time for a simple test. Below is a very simple program that basically generates a list of Ids. In one case, it’s using LINQ, and the other just Plain C#. The code is pretty self explanatory. Here are the results:
| Test Performed | Time to Do 100000 iterations |
| Using LINQ | 52ms |
| Using Simple C# | 35ms |
Well, my fears are put aside. Though LINQ is somewhat slower, for 100,000 iterations, .052 seconds is pretty good. (compared with processing a single not to complicated LINQ2SQL statement for 100,000 iterations would take about 20,000 seconds or 333 hours. Quite a difference to .052 seconds!
(more…)
