The DB will be used to store hundreds of thousands of products ( probably millions), thousands of such products will be updated every day.
This database will be used to power several websites, I don't expect the traffic to explode on these sites, but I don't want to build something with no chances to perform well.
MyISAM or INNODB? I continue to find opinions of any kind on this subject
how would you prevent websites to be slow while the database is being updated ( hence being hit by thousands of SELECT/INSERT/UPDATE queries) ?