List:MySQL on Win32« Previous MessageNext Message »
From:John Fitzsimons Date:December 5 2004 10:04pm
Subject:General database query.
View as plain text  
Suppose one has a field that is likely to have no more than 20
characters in. Would there be any practical difference between 
making it a varchar or one with a limit. 

In other words would limiting the field to 200, 100, or 20 be likely
to make much (any ?) difference ? For example, as an estimate, 
would a 100 limit be twice as fast as a 200 limit ? If only 20
characters existed.

Regards, John.
 
Thread
General database query.John Fitzsimons5 Dec
  • Re: General database query.Erich Dollansky6 Dec