Possible optimization in DbDataReader.GetStream

[TrayanZapryanov]

Do you think if it is worth using System.Buffers.ArrayPool instead of always allocating byte[4096] in default implementation of DbDataReader.GetStream() ?

https://github.com/dotnet/corefx/blob/46d9f33d96a1db41a9634b84dd68256db2eeed4f/src/System.Data.Common/src/System/Data/Common/DbDataReader.cs#L147

[Wraith2]

Possibly, but I would expect each provider to override it with a performance tuned implementation as SqlClient does. In ths SqlClient specific case I've made some optimizations on streams already in dotnet/corefx#35927 and if there are more that can be seen from specific test cases i'll probably add them.

[TrayanZapryanov]

Unfortunately neither MySQL or Oracle done it :(.

[Wraith2]

Understandable if a bit sad given their owner and platform preferences. You can try https://github.com/mysql-net/MySqlConnector for mysql it isn't first party but it's modern actively developed and the authors are interested in good performance.

[TrayanZapryanov]

Thank you.
I will redirect this proposal to MySQL.