Whether such a beast will lag, I think to use for parsing.
1 answer
The question is incorrect, because it is not the number of records. The database is capable of supporting really large amounts of data. Time will be spent on sampling, recording, updating indexes, therefore, you need to estimate the number of records in a sample, whether indices will effectively participate in samples, how many indexes there will be, and similar questions.
I can hardly give a more accurate answer to your question. I can advise you to try EXPLAIN
on frequent queries and see how much resources are spent on each of the queries.
|