Click here to Skip to main content
13,004,397 members (73,217 online)
Click here to Skip to main content
Articles » Database » Database » Utilities » Revisions


165 bookmarked
Posted 2 Jun 2012

GUIDs as fast primary keys under multiple databases

, 15 Mar 2013
Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.



Compare Revision Minor Date Status Editor
7 - publicly available Yes 15-Mar-13 22:05 Available Jeremy Todd
The article has been approved
6 No 15-Mar-13 21:39 Pending Jeremy Todd
Added GitHub link
5 No 15-Mar-13 20:50 Pending Jeremy Todd
Fixed a typo
4 No 15-Mar-13 20:39 Pending Jeremy Todd
Adopted Rich Andersen's suggestion of using DateTime.UtcNow instead of DateTime.Now, for improved performance
3 No 3-Jun-12 17:01 Available Smitha Nishant
Updates in content. 114 changes had been made.
2 No 3-Jun-12 14:43 Pending Jeremy Todd
Updates in content. 23133 changes had been made.
1 No 1-Jun-12 23:35 Pending Jeremy Todd
Initial creation


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Jeremy Todd
Database Developer University of Illinois
United States United States
Jeremy Todd is a database administrator and lead web programmer for the College of Agricultural, Communications, and Environmental Sciences at the University of Illinois at Urbana-Champaign. He enjoys work, fun, and talking about himself in the third person.

You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170627.1 | Last Updated 16 Mar 2013
Article Copyright 2012 by Jeremy Todd
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid