NServiceBus.Persistence.Sql icon indicating copy to clipboard operation
NServiceBus.Persistence.Sql copied to clipboard

We may be affected by a SQL Server performance issue with large binary data

Open kbaley opened this issue 3 years ago • 0 comments

The following bug was identified in the SqlClient: https://github.com/dotnet/SqlClient/issues/593

From the issue:

Reading a 10MB VARBINARY(MAX) value asynchronously takes around 5 seconds my machine, while doing the same synchronously takes around 20ms. Increasing the data size to 20MB increases the running time to around 52 seconds.

We haven't received reports that it affects us possibly because the threshold is high and we recommend not having messages that size (or even a tenth of that size). This issue is to track whether users are affected by this bug in case there is something we can do to work around it in the short term.

See also:

  • https://github.com/Particular/NServiceBus.SqlServer/issues/1133

kbaley avatar Dec 19 '22 17:12 kbaley