… performance? A: Recent MySQL versions are smart enough to convert id IN (5) to ID=5 (for single…VARCHAR(36) instead of auto-increment A: If you’re using UUID it is at least good to convert it in binary form and store as VARBINARY(16) for performance reasons. In any case you would likely to…
Comment: Using CHAR keys for joins, how much is the overhead ?
July 5, 2007 By 18 Comments
…to retreive the data.. Before MySQL 5.0.3, a CHAR or VARCHAR column with a length specification greater than 255 is converted to…, VARCHAR(500) is converted to TEXT, and VARCHAR(200000) is converted to MEDIUMTEXT. Similar conversions occur for BINARY and VARBINARY, except that they are converted to a…
