On Mon, Mar 3, 2014 at 8: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
>
>
>
++ https://blueprints.launchpad.net/keystone/+spec/sql-id-binary-16


>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev@lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
_______________________________________________
OpenStack-dev mailing list
OpenStack-dev@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Reply via email to