…. Data size is very small. What is the biggest problem with UUID ? It is the fact inserts are going in random locations… would work much better than UUID because UUID will have recent data scattered all across. Lookups Later in comments Brian mentions the point… in memory case or data on disk case with auto_increment having advantage when UUID larger BTREE does not fit in memory…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… hit to happen. This means if you would place dynamic comments in the query, have extra space or use different case… would simply preform select to retrieve data from table. Avoid comment (and space) in the start of the query – Query Cache… the same. So if query works with current data, uses non-deterministic functions such as UUID(), RAND(), CONNECTION_ID() etc it will…
