.NET: Avoid Using Guid.CreateVersion7(gist.github.com)
gist.github.com
.NET: Avoid Using Guid.CreateVersion7
https://gist.github.com/sdrapkin/03b13a9f7ba80afe62c3308b91c943ed
2 comments
Guid.CreateVersion7 in .NET 9+ claims RFC 9562 compliance but violates its big-endian requirement for binary storage. This causes the same database index fragmentation that v7 UUIDs were designed to prevent. Testing with 100K PostgreSQL inserts shows rampant fragmentation (35% larger indexes) versus properly-implemented sequential GUIDs.