On Mon, Mar 3, 2014 at 8:48 AM, Jay Pipes <jaypipes at 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 > > > ++ https://blueprints.launchpad.net/keystone/+spec/sql-id-binary-16 > > _______________________________________________ > OpenStack-dev mailing list > OpenStack-dev at lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140303/685adcb3/attachment.html>