Re: Size of tables: are VARCHARs efficient? How do I "narrow" this table? - pek...@mysql.com - com.mysql.lists.cluster

5 messages in com.mysql.lists.clusterRe: Size of tables: are VARCHARs effi...

From	Sent On	Attachments
Alex Davies	20 Feb 2005 05:18
Mikael Ronström	21 Feb 2005 00:03
Alex Davies	21 Feb 2005 03:20
Mikael Ronström	21 Feb 2005 05:18
pek...@mysql.com	21 Feb 2005 05:29

Subject:	Re: Size of tables: are VARCHARs efficient? How do I "narrow" this table?
From:	pek...@mysql.com (pek...@mysql.com)
Date:	02/21/2005 05:29:02 AM
List:	com.mysql.lists.cluster

Might actually help. TEXT fields have the first 32 (unsure if this is the correct figure) bytes stored in the main record and the rest is stored in 512 bytes records.

Does not help this case.

inline part-size approx blob 256 2000 medium blob 256 4000 long blob 256 8000

inline = in original table part-size = in each NBD$BLOB row

It could be made more configurable but it still does not look like good solution to varchar(200).