[Performance] Revert buffering by default


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 23, 2013 at 12:20 AM by lukew
Verified using LINQ, SPROCs, Raw SQL, and querys that we use the correct strategy for default (Streaming) and retries on failure (Buffering).


emilcicos wrote Nov 18, 2013 at 6:16 AM

Fixed in changeset 60340c753215896bc2a6cc2a98cc813979af25c2

emilcicos wrote Nov 18, 2013 at 9:53 PM

Fixed in changeset d5d50b393d3806a9e0375e0ff16c946a5a93545a