3 ms·
not if linq is constructing the queries, according to the article, which i think is what we were discussing.
by andrewcooke 17y ago
not if linq is constructing the queries, according to the article, which i think is what we were discussing.
- jasonkester 17y agoYou started this thread by asking about SQL Server itself (and the way it handles query plans in particular). That's what we've been talking about ever since. Not Linq. You might want to go back and read the responses to your question again to make sure you've got your context right.
- andrewcooke 17y agoi see your point, and it was wrong of me to describe the context in that way. on the other hand, your previous statement was qualified with "in the real world", and to some extent the "real world" includes people using linq. having said that, i agree that the consensus - if i haven't misunderstood something else - seems to be that sql engines don't do what i expected because it's assumed that people will use compiled statements. i don't use linq myself so am having to infer a lot from the article, but at some point i plan to check django and sqlalchemy to see when they use precompiled statements and when not.