解决方法
仅添加rowversion / timestamp列的性能差异是您的行现在宽8个字节.
当您开始实际使用它们时,实际的性能差异就会出现.但正如我在回答类似问题时指出的那样:RowVersion and Performance
If you’re not going use the
rowVersion
field for checking for updated items and instead you’re going to use it for consistency to ensure that the record isn’t updated since you last read,then this is going to be a perfectly acceptable use and will not impact.Such As:
UPDATE MyTable SET MyField = ' @myField WHERE Key = @key AND rowVersion = @rowVersion