On Mar 3, 2014, at 6:48 AM, Jay Pipes <jaypi...@gmail.com> wrote: > On Sun, 2014-03-02 at 12:05 -0800, Morgan Fainberg wrote: >> Having done some work with MySQL (specifically around similar data >> sets) and discussing the changes with some former coworkers (MySQL >> experts) I am inclined to believe the move from varchar to binary >> absolutely would increase performance like this. >> >> >> However, I would like to get some real benchmarks around it and if it >> really makes a difference we should get a smart "UUID" type into the >> common SQLlibs (can pgsql see a similar benefit? Db2?) I think this >> conversation. Should be split off from the keystone one at hand - I >> don't want valuable information / discussions to get lost. > > No disagreement on either point. However, this should be done after the > standardization to a UUID user_id in Keystone, as a separate performance > improvement patch. Agree? > > Best, > -jay
-1 The expectation in other projects has been that project_ids and user_ids are opaque strings. I need to see more clear benefit to enforcing stricter typing on these, because I think it might break a lot of things. Vish
signature.asc
Description: Message signed with OpenPGP using GPGMail
_______________________________________________ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
