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@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.