I want to develop an application for which i will need a database to store data. I am using MySQL as backend. My question is
Which MySQL engine should i use?
Well, i have mentioned some important characteristics of operations that will be performed on db:
- 99.99% read operations.
- I don't need foreign-keys.
- I don't need transactions.
- Simple read operations and nothing else.
I know that
InnoDB is latest
default engine in MySQL. But, as far as i can conclude, i don't need most of the features which are main reasons to use InnoDB. So, now i am left with
I am thinking of using
MyISAM as i just want to read data from database. I have refered the official documentation for storage engines and also googled it. But, still may be that my knowledge-base is lacking some important updates. So, i am seeking help from community.
Is my choice of using
MyISAM storage engine for specified scenario proper?
Thanking Community in anticipation.
I thank ypercube to help me narrow-down my choice.