This is Jon Raynor's Typepad Profile.
Join Typepad and start following Jon Raynor's activity
Join Now!
Already a member? Sign In
Jon Raynor
Recent Activity
The whole point here is the LINQ to SQL compilation time is trivial. Its only a few extra ms per call, and that is happening on the web server, not the database server. So, spending time compiling those queries will only give a slight boost in performance and it is not worth doing if your only gaining a few extra ms. I'd be more worried about the SQL that the LINQ compiler is generating. After all, the database runs SQL statements not LINQ ones. A little tougher to debug since the actual SQL is abstrated out by LINQ. But you can still trace things out and see what is going on in SQL land. Anyway, you want to avoid this, write a stored proc, open a connection and run the proc with a command. Process the results with a data reader. Then there is 0 compilation time with LINQ.
Toggle Commented Apr 19, 2010 on Compiled or Bust? at Coding Horror
Jon Raynor is now following The Typepad Team
Apr 19, 2010