MySQL Hash Tables

[Frank_Rizzo]

[note Title should read MySQL HEAP Tables]

I understand that HEAP [edited from Hash] tables are temporary tables which are held in memory.

If datbases are just used for searching only, and there is no facility for writing, updating, inserting, deleting, then isn't it a good idea to put all tables into HEAP tables and just run queries from those as this would remove disk access bottlenecks?

Good idea or not?

[edited by: Frank_Rizzo at 10:42 pm (utc) on Feb. 8, 2003]

[andreasfriedrich]

Sure, but keep in mind that other tables will be cached in memory as well if there is enough physical memory available and MySQL [mysql.com] is configured to use it.

Andreas