Hrmm, actually from this: http://kekoav.com/blog/36-computers/58-uuids-as-primary-keys-in-mysql.html
and this: http://www.mydatabasesupport.com/forums/mysql/246972-uuid-datatype.html ... it seems one really does need to use binary(16) and then perform a hex conversion, otherwise there isn't a performance increase. But CakePHP requires the length of 36 with a binary type. Any thoughts? On May 21, 5:09 pm, Aaron Shafovaloff <aarons...@gmail.com> wrote: > Just a heads up: CakePHP, as of about 2 months ago I think, supports > UUIDs as a binary primary field type instead of just char. > > See: > > https://trac.cakephp.org/ticket/4119 > > I believe the field length still has to be 36. > > From this: > > http://www.mysqlperformanceblog.com/2007/03/13/to-uuid-or-not-to-uuid/ > > I think I gather that using the binary field type brings it down to 16 > bytes instead of 36 bytes (even though the field length is left at > 36?). > > Take care, > > Aaron --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---