|
|
|
|
|
|
by pauldbau
4252 days ago
|
|
|
For .NET / SQL Server people, check out GuidCombs if you want better Primary Key performance.
These are a great way of making GUIDs sequential for database use, giving indexing performance close to ints on SQL Server. I imagine this approach could also work on Postgres and other dbs that have made GUID/UUIDs a first class data type.
You'd just have to understand how that database applies its indexing algorithm. Description of the GuidComb approach here:
http://www.informit.com/articles/article.asp?p=25862 GuidComb implementation in C# (from NHibernate core) here:
https://github.com/nhibernate/nhibernate-core/blob/master/sr... |
|
|