LINQ queries performance improvement....need help

Question

LINQ queries performance improvement....need help

s1123

Mr or Mrs. 500

Points: 567
More actions
May 2, 2012 at 7:18 am

#273445

Hi guys,
my manager told me today, that in the upcoming projects the develpment team gonna use LINQ queries..
so , he asked me to find how to tune/improve those linq queries...
can anybody suggest me , how? and where to start..
any help is much appreciated.
thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

The best thing you can do is to continue to use stored procedures. That way you continue to have 100% control over the sql that is being executed on your server.

Here is an example of using LINQ with stored procs.

http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

s1123 Mr or Mrs. 500 Points: 567 More actions · Answer 2

hi .. thnx for the link

sry

Just confirmed, they are using LINQ to Entities..

can any one tell me how to tune those queries?

can i profiler and DTA for max performance? or is there any other thing?

thanks

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Entity Framework can also use stored procs. Keep your sql close at hand and don't let EF take over. It has gotten a lot better in the last couple versions about not creating hideous sql but I would still prefer to know exactly what the t-sql looks like. 😛

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/