You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Have 2 table structures and based on the incoming message ID value format to use the UUID table or the string value table
ramonsmits
changed the title
SqlServer Outbox: Support using uniqueidentifier for messageid to reduce storage
SQL Server Outbox: Support using uniqueidentifier for messageid to reduce storage
May 31, 2024
Instead of using
nvarchar(200)
as the type for message id support uniqueidentifier to reduce the storage size of both the rows and the index.In most environments message id will contain a UUID. It allows a string but that comes as a cost.
A
uniqueidentifier
is 16 bytes while currentlynvarchar(200)
results in 36 16 bit chars which results in 72 bytes per row.This saves 56 bytes per row and would reduces the index size significantly.
The text was updated successfully, but these errors were encountered: