Just bear in mind that UUIDs may not always be 128bit. Although frankly that's unlikely to the be case unless inbound-use-callid-as-uuid is used so if this is for your own application then that should be fine. -Steve On 17 February 2013 20:55, Cal Leeming [Simplicity Media Ltd] < cal.leeming@simplicitymedialtd.co.uk> wrote:
Hi all,
Just spent a little while comparing the performance of heavy INSERT/SELECT performance against UUID fields in a MySQL database.
Full performance breakdown and write up can be found here; http://blog.simplicitymedialtd.co.uk/?p=437
So far, the best option seems to be storing the UUID as a BINARY(16) - anyone have any thoughts on this?
Thanks
Cal
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org