1

Closed

[Performance] Revert buffering by default

description

Related to #1786 and possibly #1781, the change to buffering is being more impactful than we initially thought it would be. Testing against the provided repros yields performance degradation of 103% and 36% respectively.

We now think the best thing to do is to revert back to streaming by default. In particular:

1) Change default query execution back to streaming. But,
2) Use buffering if the current IDbExecutionStrategy retries on failure.
3) Deprecate the AsStreaming() extension method.
Closed Nov 22, 2013 at 11:20 PM by lukew
Verified using LINQ, SPROCs, Raw SQL, and querys that we use the correct strategy for default (Streaming) and retries on failure (Buffering).

comments

emilcicos wrote Nov 18, 2013 at 5:16 AM

Fixed in changeset 60340c753215896bc2a6cc2a98cc813979af25c2

emilcicos wrote Nov 18, 2013 at 8:53 PM

Fixed in changeset d5d50b393d3806a9e0375e0ff16c946a5a93545a