I'm coming up with a web app which will want me to store more than 8 million rows. Will it be fine to handle those many number of rows with MySQL without having any performance degradation?
Assume my RAM to be 4 GB and Infinity GB Harddisk space. Also, the main fields have been indexed.