Kevin, First the stuff MySQL calls UUID are GUID at least if you use Wikipedia definition: http://en.wikipedia….’re describing completely different problem which is not about using GUID vs AutoIncrement. In your case you want the key to identify… point – this corresponds to simple swap of auto_increment to UUID without changing application design or anything which is in my…

… improve the situation, I created a simple UUID class capable of generating random UUID‘s with an option to store them in… 22-byte UUID representation (VTIW7xOgReOGrL3vMRjm4Q, for example). The performance increase was enormous, and the overhead is much smaller (22 bytes vs. 16… between speed and uniqueness. They can also be translated to GUID‘s (########-0000-0000-0000-00##########) and back when needed. (If…