Re: Optimizing column widths

2011-06-19 Thread Tim Johnson
* Dan Nelson dnel...@allantgroup.com [110618 16:33]: 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

Optimizing column widths

2011-06-18 Thread Tim Johnson
Is there an optimal 'alignment' for column widths for varchar types? I.E., divisible by 8 or 10 or by powers of 2? URLs to documentation would be more than sufficient. Version 5+, linux platforms. thanks -- Tim tim at johnsons-web dot com or akwebsoft dot com http://www.akwebsoft.com --

Re: Optimizing column widths

2011-06-18 Thread Dan Nelson
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