[drupal-devel] MySQL HEAP-tables

[Gabor Hojtsy]

> And reading further, its memory waste may be huge. It says:
> 
>>MEMORY tables use a fixed record length format.
> 
> So even if we change the longtext and text in the cache table to be
> varchar, it will still be treated as char, and A LOT OF memory would
> be wasted.

And you cannot change it to (var)char, since cache entries mostly exceed
the 256 chars length.

Goba