[drupal-devel] MySQL HEAP-tables

Khalid B kb at 2bits.com
Mon Sep 12 17:39:43 UTC 2005

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.

More information about the drupal-devel mailing list