From: Paul R. J. <pa...@ps...> - 2003-07-06 21:26:51
|
Another thing (that James may be alluding to in the previous post): Char is nearly always better than varchar for speed in mysql (where char is possible of course), however varchar may result in smaller tables (disk size). This is because Varchar results in the table having dynamic record sizes, which means indexing is slower (i.e. lookups), where as char allows for fixed width records (faster). See: http://www.mysql.com/doc/en/CHAR.html Just thought I would throw this in because I know that it is something that I overlooked for a long long time. |