Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saurabhsrivastava
Posting Yak Master
216 Posts |
 Posted - 2009-02-05 : 13:18:08
|
| Any known performance issues using LINQ-TO-SQL with SQL Server 2005. I'm looking for both x-64 and IA-64 versions as one of my customer is using this combination. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2009-02-10 : 12:57:02
|
| I don't know of any specific performance problems related to using LINQ - after all, LINQ simply translates your LINQ queries to corresponding SQL queries the best way it knows how. One thing you might want to be careful about is performance hit that may occur due to lazy loading. Typically, this happens when you are iterating through a collection and each iteration triggers a round trip to the database to fetch one item (and that is not a precise definition).Some useful info here: http://www.sidarok.com/web/blog/content/2008/05/02/10-tips-to-improve-your-linq-to-sql-application-performance.html |
 |
|
|
|
|
|
LINQ-TO-SQL with SQL Server 2005