[drupal-devel] MySQL HEAP-tables

[Khalid B]

I used to be wary of such esoteric features, since although I can have
them at home, hosting would not allow them, specially for shared
hosting environments.

However, it seems that lately, hosting companies have been providing
support for these extra storage engines, such as InnoDB and
MEMORY/HEAP. If you are in doubt, check in PHPMyAdmin under "Storage
Engines" and see what is listed there.

So, yes, it is a valid option, and since it only affects table
creation, it should have no impact on PostgreSQL or ANSI
compatibility.

On 9/12/05, Dries Buytaert <dries.buytaert at gmail.com> wrote:
> Did someone experiment with MySQL's memory storage engine (HEAP
> tables)?  If not, I'll add it to my TODO list.  Sounds fun and from
> the looks, the cache table would be a good candidate ... See http://
> dev.mysql.com/doc/mysql/en/memory-storage-engine.html for more
> information.