…benchmarks I decided to do Join not on primary key and have query to read data for both …- latin1 encoding is enough for most character based keys – uuid, sha1/md5 based etc. Latin1 encoding indeed gave… Finally I decided to check if using longer strings slows down things significantly and so I …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…WHERE hash=crc32(‘string‘) AND string=’string‘ The other thing you need to consider is string comparison in MySQL…increment be used as primary key? A: Auto-increment is a good default primary key. You should pick… said that there are many people using UUID rather successful in applications which do …
Comment: To UUID or not to UUID ?
December 15, 2007 By 28 Comments
… the auto_increment primary key and then using a persons First, Middle and Last name to search for the UUID implementation. Write a… back to a characters string with hyphenation if you need to display it. However, the primary use for UUIDs or GUIDs is data… data stored in many locations you have to manage this primary key much closer and have the ability to generate something that…
