Professional Development – 2024 – Week 28

Image Credit: https://www.flickr.com/photos/54585499@N04/

.NET

The New ID to Replace GUIDs and Integers in .NET (via Nick Chapsas)

This is being introduced in .NET 9, and has to do with relational databases. The issue with GUIDs is that they can cause performance issues when used as primary keys. Auto-ordered integers also has problems (although the video did not explain why). Current GUIDs are based on UUID 4; the new concept is based on UUID 7 where the first 47 of 128 bits are time-ordered. (See this RFC for more information.) Because the time values are sequential, it makes indexing more performant.