| 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 Fitzsimons | 5 Dec |
| • Re: General database query. | Erich Dollansky | 6 Dec |
