I have a database with size about 170GB with rows between 20.000 - 700.000.000 rows (depending on the table). Currently i'm using MyISAM storage engine.
In my case, querying (READ) speed is very important, but transactional is optional.
My CRUD Operation estimates is :
- 98% READ
- 2% INSERT
- < 1% for both UPDATE & DELETE