I currently store some boolean values in tinyint(1) unigned fields. When running the procedure analyze on my tables, I am told that the best data type for these fields would be an enum(0,1). Is that true? How is that faster than tinyints?
Also, does specifying the length of an integer-type field (say 1 for tinyint) make any difference on speed/storage issues?
Thanks,
Pierre-Luc
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
