What is the maximum number of rows that can be contained in a table without a large loss in the speed of retrieval from it?

Question

MySQL

Let's say there is a table with more than a million rows, this is the main table, which is constantly being
queried. Is this advisable? Should I split it into multiple tables?
What if there are more than 10 million rows? 100 million?

Answer 1

The number doesn't matter.
Plays a role:
1) Whether indexes get into the storage taken away for them.
2) Is there enough IO on the disk to write data.
3) Is there enough processor to rebuild the indexes.
Accordingly, when one of these parameters is exhausted, performance sags.

Answer 2

well a trillion