Blog

The Cost of GUIDs as Primary Keys

October 24, 2006

Today I've read an excellent article written by Jimmy Nilsson about The Cost of GUIDs as Primary Keys. A must-read article when your using GUIDs as primary keys in your database.

I must admit that I have been always against using GUIDs as a primary key because of the bad performance you get when having tables with lots of records. After reading this article, I believe that COMBs will solve this issue.

PS: I can strongly recommend you to get a copy of Applying Domain-Driven Design and Patterns. Two thumbs up!

Profile picture of Jan Van Ryswyck

Jan Van Ryswyck

Thank you for visiting my blog. I’m a professional software developer since Y2K. A blogger since Y2K+5. Curator of the Awesome Talks list. Past organizer of the European Virtual ALT.NET meetings. Thinking and learning about all kinds of technologies since forever.

Comments

About

Thank you for visiting my website. I’m a professional software developer since Y2K. A blogger since Y2K+5. Curator of the Awesome Talks list. Past organizer of the European Virtual ALT.NET meetings. Thinking and learning about all kinds of technologies since forever.

Contact information

(+32) 496 38 00 82

infonull@nullprincipal-itnull.be