taylorsharpe

UUID hex verses Decimal Serial Number for Primary Key

Discussion created by taylorsharpe on Jan 4, 2015
Latest reply on Jan 8, 2015 by HOnza

I was reading some comments from Todd Geist and used by John Sindalier about using a key field that is a number field being better for indexing than with text such as you get with the hex from a UUID value.  I was wondering if anyone has really compared and found a difference in performance between the two and it is worth the effort to convert a hex UUID to decimal for indexing.  I was just wondering if it was worth taking the time to do the conversion for UUID fields. 

Outcomes