3 to 4 Millions of records in a single table

[honey ruby]

Hi, If there is millions of record in a single table of mysql db and it is already indexed and having such huge no of records will slow down the process of query. In such cases what are the steps need to take. Kindly give your suggestions.







Thanks In Advance

[Hassan Schroeder]

On Wed, Dec 14, 2016 at 4:21 AM, honey ruby <emailtoh...@gmail.com> wrote:
> Hi, If there is millions of record in a single table of mysql db

That's not that many records.

If this question is theoretical it's premature optimization :-)

If you think you really have a slow query problem, you need to look
at the specifics: use mysql's EXPLAIN to examine what your query
is actually doing.

--
Hassan Schroeder ------------------------ hassan.s...@gmail.com
twitter: @hassan
Consulting Availability : Silicon Valley or remote