I have following question: I am designing web application with several dozens of small lookup tables: These tables usualy contain three columns (ID, Name, Description) and a couple of rows (mostly fewer than 50, max is about 450).
These lookup tables are expected to change only rarely (they come from standard, which changes once in several years) and will be used only to:
- fill options in html select
- be joined to other records in reports
There will be only SELECT
statements on these tables 99 % of times, but there will be quite a lot of them.
I am wondering, which database engine would be most efficient to use?
Here are my considerations:
MEMORY
- pro: very fast
- con: if the server crashes, all data are lost and need to be recreated
- con: does not support foreign keys
compressed MyISAM
- pro: fast
- con: does not support foreign keys
InnoDB
- pro: foreign key support
What I would like to ask, is whether there will be significant advantage in using something different than InnoDB - performance-wise
Thanks, Zbynek