>From the manual: "If you don't have any variable-length columns (VARCHAR, TEXT or BLOB columns), a fixed-size record format is used. This is much faster but unfortunately may waste some space."
Can anyone more precisely quantify how significant is the difference in performance if the table uses all CHAR fields versus all VARCHAR fields? Also, if VARCHAR() is used in a table, what would be the reason to use, say VARCHAR(25) rather than always simply using VARCHAR(255)? V Harris