Reputation
649
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
9 19
Impact
~19k people reached

  • 0 posts edited
  • 1 helpful flag
  • 84 votes cast
Jan
7
revised cost trade-offs for deploying changes to prod, stored procs vs. LINQ
edited title
Jan
7
comment T-SQL stored procs orders of magnitude faster than LINQ
But those JOIN questions (lol) aren't mine. One of the LINQ providers I wrote does support JOINs. stackoverflow.com/a/6350766/266457. And for any functions which don't have a direct T-SQL translation, the Expression tree can still be evaluated as much as possible, and let the remainder of the Expression tree be evaluated in .NET - besides the fact that the query could otherwise be immediately executed, and then run the Regex/financial functions w/ LINQ to objects afterwards.
Jan
7
comment T-SQL stored procs orders of magnitude faster than LINQ
@qes I'm aware of limitations of LINQ, e.g. the following throws an exception in LINQ2SQL VS2010, even though the second part of the BinaryExpression shouldn't need to be evaluated: int? version = null; var books = db.Textbooks.Where(b => version == null || b.Version == (int)version); Trig and financial functions don't seem to be of them. e.g. where is the issue in running the following? var courses = db.Courses.Where(c => Math.Sin(c.Credits) != 1).ToArray(); Most financial (and trig) functions seem to require scalar parameters anyway, not rowsets.
Jan
7
revised cost trade-offs for deploying changes to prod, stored procs vs. LINQ
added 224 characters in body
Jan
7
asked cost trade-offs for deploying changes to prod, stored procs vs. LINQ
Jan
6
comment T-SQL stored procs orders of magnitude faster than LINQ
@qes: Trig functions not happening? How about financial functions? I definitely see those commonly in stored procs. Iteration w/ state not happening? FETCH. msdn.microsoft.com/en-us/library/ms180152.aspx String manipulation? Last time I checked LINQ to SQL, the String functions were supported. Besides that, string, regex functions that show up in the SELECT statement are easily applied after the call to IQueryProvider.Execute. programmers.stackexchange.com/a/65810/19936
Jan
6
comment T-SQL stored procs orders of magnitude faster than LINQ
@qes: Yes I do. More than 2, but not dozens, and I've written 2. Which are the dozens you've worked with? It seems that simplest table selects cannot be that different across different providers (and besides contradicting "cannot generalize"), how differently can a stored proc represent a simple select than LINQ to SQL can generate the equivalent T-SQL? The LINQ-to-T-SQL translators are already provided by the ORM framework, so where's the fight?
Jan
6
comment T-SQL stored procs orders of magnitude faster than LINQ
@qes: A good comment, but I doubt this. Cannot generalize? Is the generated T-SQL or the algorithms used to generate it from e.g. LINQ-to-SQL and Entity Framework, really so fundamentally different? By time-consuming here I assume you mean development time, not running time (i.e. the question)? Even still, not necessarily. For example, suppose your query involved concatenation, other string manipulation, iteration,with persistence of some state from one row to the next, and calls to trigonometry functions...
Jan
6
asked T-SQL stored procs orders of magnitude faster than LINQ
Dec
16
comment How to deal with people who don't want to share knowledge?
Ask yourself from their perspective, what's the benefit to them and not the team, for putting their time and effort into doing the extra work of documentation?
Dec
3
comment Why don't all companies buy developers the best hardware?
"The difference of productivity between...machines is negligible. The difference in price is significant." What is the value if you were to quantify this negligible difference? -10 min/day ? Suppose the top-end machine is $3000, and assume that almost-top-end is almost-$3000, or $2500. The difference is $500 a fixed cost distributed over 2-3 yrs. Is this your definition of significant?
Dec
3
awarded  Critic
Dec
3
comment Why don't all companies buy developers the best hardware?
Anandtech has come up with some interesting ways of quantifying performance and cost. anandtech.com/bench/CPU/2
Oct
9
accepted Prevalence of “back end” programmer roles in ASP.NET (MVC) projects?
Oct
9
asked Prevalence of “back end” programmer roles in ASP.NET (MVC) projects?
Sep
27
awarded  Nice Question
Aug
15
awarded  Popular Question
Jul
21
comment Should Professional Development occur on company time?
@Joonas +1 again, great quote, but then isn't that the reason why it actually might hurt to ask?
Jul
17
comment How to market yourself as a software developer?
+1 and don't forget to add these under the "Skillz" section on your resume.
Jul
12
comment I don't program in my spare time. Does that make me a bad developer?
Then you need to also compete with those that aren't.