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!

If you and your team want to learn more about how to write maintainable unit tests and get the most out of TDD practices, make sure to have look at our trainings and workshops or check out the books section. Feel free to reach out at infonull@nullprincipal-itnull.be.

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. Provider of training and coaching in XP practices. 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

Latest articles

Tags

Disclaimer

The opinions expressed on this blog are my own personal opinions. These do NOT represent anyone else’s view on the world in any way whatsoever.

About

Thank you for visiting my website. I’m a professional software developer since Y2K. A blogger since Y2K+5. Author of Writing Maintainable Unit Tests. Provider of training and coaching in XP practices. Curator of the Awesome Talks list. Thinking and learning about all kinds of technologies since forever.

Latest articles

Contact information

(+32) 496 38 00 82

infonull@nullprincipal-itnull.be

principal-it.eu
principal-it.be
janvanryswyck.com