spicedb icon indicating copy to clipboard operation
spicedb copied to clipboard

upsert overlap

Open ecordell opened this issue 2 years ago • 1 comments

This uses an UPSERT to create transaction overlap in CRDB. In benchmarks it appears to be slightly faster than the INSERT ... ON CONFLICT

ecordell avatar Mar 31 '23 20:03 ecordell

Recent CRDB release notes make it sound as though SELECT FOR UPDATE may work for overlap now - it's worth re-running the tests with new versions.

ecordell avatar May 31 '24 11:05 ecordell