Tag LINQ

Entries 1 Total

LINQ to SQL may cause performance problems

Aug 28, ’08 8:47 PM

Marco Russo posted about a possible LINQ to SQL performance problem.
Using AdventureWorks for our sample, we might have a stored procedure to select from the Production.Product table:
[viewcode] src=”http://facility9.com/files/2008/08/create_getproductbyname.sql” showsyntax=”no” link=”yes” [/viewcode]
Calling this procedure will always use the same cached execution plan and will only be re-compiled if/when the procedure is consciously changed by a DBA [...]

Continue Reading… Comments (0)