Linq to Sql Surprise Performance Hit

Loading...

Why not join our community?, there are 13 users online

home
linq
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

30
kicks

Linq to Sql Surprise Performance Hit

published 11 months, 28 days ago, submitted by jconley 1 year ago

jdconley.com — JD outlines a classic case of making assumptions while performance tuning. It turns out there are cases where Linq To SQL can take longer to compile a query than the round trip to SQL.

2 comments | category: Linq | Views: 6 | Get KickIt image code

tags: ToRead, Tuning, LINQ | tag it

Everyones tags:

Your tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

Anastasiosyal -

justin_etheredge -

offwhite - markheath - traskjd -

mrkurt - braddunbar -

ColinCochrane - dkjariwala - trinity - buddydvd - zvikara -

johnrummell - rjdudley - JoHofmann -

brianjlowry - Loonquawl - csharpnjava - Reman - khushal999p -

stenbaek - munchr -

Comments:

Excellent example of turning a performance-eating Linq query into a slim, compiled one, but he doesn't address why a simple application needs to hit the database over 1.1 million times just to load the page 3 times. That's crazy talk.

posted by jesse 11 months, 27 days ago

better be nice, he'z a h4x0r

posted by bladefist 11 months, 21 days ago

information

Login or create an account to comment on this story

Sponsored Link: www.carlist.ie

Search:

Ads via The Lounge

You are the editor:

View upcoming stories

Submit a story

How else can I help?

Earn money