…When you apply it though remember hash can have collisions so you will need to have your queries … fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal …. Having said that there are many people using UUID rather successful in applications which do not need …
Comment: To UUID or not to UUID ?
April 15, 2008 By 28 Comments
… have seen those problems with UUID‘s in MySQL when stored as text. Ideally, MySQL would have a UUID column type to store the… improve the situation, I created a simple UUID class capable of generating random UUID‘s with an option to store them in… a new identifier that was only 72 bits. (Yes, the collision probability goes up, but it is still one in 4…
