LINQ queries performance improvement....need help

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » LINQ queries performance improvement....need...

LINQ queries performance improvement....need help

Rate Topic

Display Mode

Topic Options

Author

Message

s1123

Posted Wednesday, May 02, 2012 7:18 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, June 14, 2012 11:11 PM
Points: 39, Visits: 197

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

Post #1293816

Sean Lange

Posted Wednesday, May 02, 2012 8:28 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 3:12 PM
Points: 8,957, Visits: 8,523

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1293880

s1123

Posted Wednesday, May 02, 2012 8:39 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, June 14, 2012 11:11 PM
Points: 39, Visits: 197

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

Post #1293895

Sean Lange

Posted Wednesday, May 02, 2012 8:41 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 3:12 PM
Points: 8,957, Visits: 8,523

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. Tongue

_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1293900

« Prev Topic | Next Topic »

Permissions