9 Replies Latest reply on Jan 8, 2015 2:21 PM by HOnza

    UUID hex verses Decimal Serial Number for Primary Key

    taylorsharpe

      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.