This repository was archived by the owner on Aug 15, 2024. It is now read-only.

Improve MsSql append performance - #117

Merged

damianh merged 4 commits into

SQLStreamStore:masterfrom

yreynhout:improve-mssql-append

May 2, 2018

Commits on Apr 28, 2018

Replaced query for latest stream position by SCOPE_IDENTITY. Replaced query for latest stream version by computation based on new stream messages. Simplified metadata stream query (now uses index s…
yreynhout
committed
5403f11
Applied similar changes to ExpectedAny and ExpectedNoStream sql scripts. Applied locks to ExpectedVersion script.
yreynhout
committed
0ac04cc
Fixed an oversight while copy / pasting: when no stream the latest stream version logic can be simplified.
yreynhout
committed
d7399b7
Injected the fact there are messages or not as a parameter and made the rest of the logic conditional based on that fact (applies to ExpectedVersion.Any/NoStream only).
yreynhout
committed
048efb2