>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

Reply via email to