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.

Some time back, Winfried Huslik did some comparisons. The difference in indexing is significant, both in terms of file size and in terms of speed. (You might be able to find his results if you search the forum.)

Jeremy Bante has posted a numeric UUID CF (FileMaker Custom Function:UUIDRandom) that appears to fit the bill. But you probably know that already.

About the only downside is the need to jump through some hoops to implement a multi-key if you go the numeric route. But you probably know that already, too.

Mike