NServiceBus.Persistence.Sql
NServiceBus.Persistence.Sql copied to clipboard
We may be affected by a SQL Server performance issue with large binary data
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