May 22, 2012

Post: Using CHAR keys for joins, how much is the overhead ?

June 18, 2007 By 18 Comments

…CHARSET=utf8 mysql> select sum(t1.i+t2.j+length(t2.c)+t1.j) from intjoin t1 left join … set which we had as default ? Joining on Char columns completes in 4.5 seconds on Innodb which …- latin1 encoding is enough for most character based keys – uuid, sha1/md5 based etc. Latin1 encoding indeed gave …

Filed Under: Insight for Developers Tagged With: , , ,