| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Dan Nelson | Date: | June 19 2011 12:22am |
| Subject: | Re: Optimizing column widths | ||
| View as plain text | |||
In the last episode (Jun 18), Tim Johnson said: > Is there an optimal 'alignment' for column widths for > varchar types? > > I.E., divisible by 8 or 10 or by powers of 2? No. Varchar fields are stored using only as many bytes as are in that particular entry. The size in the column definition is simply the maximum allowed size. http://dev.mysql.com/doc/refman/5.5/en/char.html -- Dan Nelson dnelson@stripped
| Thread | ||
|---|---|---|
| • Optimizing column widths | Tim Johnson | 19 Jun |
| • Re: Optimizing column widths | Dan Nelson | 19 Jun |
| • Re: Optimizing column widths | Tim Johnson | 19 Jun |
