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 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
-~--~~~~--~~--~--~---