I have a database for my catalog webpage. Some tables are about 3GB with millions of rows.
What engine should I choose for my database, InnoDB or MyISAM?
There will only be about 1,000 new records a week, and about 1,000 deletes, but I will modify some data in one table quite often (price, quantity, etc.). All other tables will be "sealed".
I need indexes to enable fast queries. Which storage engine is best for this scenario?