[drupal-devel] MySQL HEAP-tables

[Khalid B]

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.

On 9/12/05, James Walker <walkah at walkah.net> wrote:
> 
> On 12-Sep-05, at 11:31 AM, Dries Buytaert wrote:
> 
> >   Sounds fun and from the looks, the cache table would be a good
> > candidate
> 
> well, except for : MEMORY doesn't support BLOB or TEXT columns.
>