There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
[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.