Click here to Skip to main content
15,902,829 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Quick Poll Pin
Andreas Mertens20-Jun-23 5:32
professionalAndreas Mertens20-Jun-23 5:32 
GeneralRe: Quick Poll Pin
Sander Rossel20-Jun-23 5:42
professionalSander Rossel20-Jun-23 5:42 
GeneralRe: Quick Poll Pin
darktrick54420-Jun-23 1:55
darktrick54420-Jun-23 1:55 
GeneralRe: Quick Poll Pin
WPerkins20-Jun-23 2:58
WPerkins20-Jun-23 2:58 
GeneralRe: Quick Poll Pin
kmoorevs20-Jun-23 3:11
kmoorevs20-Jun-23 3:11 
GeneralRe: Quick Poll Pin
vbproapps20-Jun-23 3:34
vbproapps20-Jun-23 3:34 
GeneralRe: Quick Poll Pin
Andreas Mertens20-Jun-23 5:26
professionalAndreas Mertens20-Jun-23 5:26 
GeneralRe: Quick Poll Pin
jschell20-Jun-23 6:16
jschell20-Jun-23 6:16 
Kevin Marois wrote:
Linq-To-SQL


Certainly I do not want to use it.

I learned this when I started SQL profiling and found that linq, with no warning at all, will not necessarily convert to SQL. Instead it can pull data in the application and then process it there.

This can lead to a single linq expression ignoring the filter clauses entirely and pulling the entire table into the application. Not hypothetical by the way, I have encountered exactly that.

I have also seen it do something similar with linq that should have produced a single SQL join. Instead it did two database queries and then correlated the two in the application.

In another case it ended up doing a while loop, again from a single linq statement, which resulted in 200+ database calls.

My expectation then is that unless the statement is very simple that I will have to profile every linq statement (and variation.)
GeneralRe: Quick Poll Pin
Gary R. Wheeler20-Jun-23 15:03
Gary R. Wheeler20-Jun-23 15:03 
GeneralRe: Quick Poll Pin
TNCaver21-Jun-23 3:01
TNCaver21-Jun-23 3:01 
GeneralRe: Quick Poll Pin
James Curran21-Jun-23 8:03
James Curran21-Jun-23 8:03 
GeneralI like simple problems. Pin
OriginalGriff19-Jun-23 3:34
mveOriginalGriff19-Jun-23 3:34 
GeneralRe: I like simple problems. Pin
Slacker00719-Jun-23 3:59
professionalSlacker00719-Jun-23 3:59 
GeneralRe: I like simple problems. Pin
Gary R. Wheeler20-Jun-23 15:17
Gary R. Wheeler20-Jun-23 15:17 
GeneralRe: I like simple problems. Pin
Gerry Schmitz19-Jun-23 5:21
mveGerry Schmitz19-Jun-23 5:21 
GeneralWSO CCC OTD 2023-06-19 Pin
OriginalGriff18-Jun-23 21:32
mveOriginalGriff18-Jun-23 21:32 
GeneralRe: WSO CCC OTD 2023-06-19 Pin
pkfox18-Jun-23 22:24
professionalpkfox18-Jun-23 22:24 
GeneralRe: WSO CCC OTD 2023-06-19 - we have a winner! Pin
OriginalGriff18-Jun-23 22:35
mveOriginalGriff18-Jun-23 22:35 
GeneralRe: WSO CCC OTD 2023-06-19 - we have a winner! Pin
pkfox18-Jun-23 22:52
professionalpkfox18-Jun-23 22:52 
GeneralNow I got it... Pin
Kornfeld Eliyahu Peter18-Jun-23 20:19
professionalKornfeld Eliyahu Peter18-Jun-23 20:19 
GeneralHappy Birthday Carlo! Pin
OriginalGriff18-Jun-23 18:14
mveOriginalGriff18-Jun-23 18:14 
GeneralRe: Happy Birthday Carlo! Pin
CPallini18-Jun-23 20:08
mveCPallini18-Jun-23 20:08 
GeneralRe: Happy Birthday Carlo! Pin
Richard MacCutchan18-Jun-23 21:08
mveRichard MacCutchan18-Jun-23 21:08 
GeneralRe: Happy Birthday Carlo! Pin
CPallini18-Jun-23 21:18
mveCPallini18-Jun-23 21:18 
GeneralRe: Happy Birthday Carlo! Pin
Nelek19-Jun-23 12:06
protectorNelek19-Jun-23 12:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.