title: MySQL statement takes more than minute to execute
body: <p>I am working on a website in which the database is huge. 1 million records are in the table at the time. When I perform a query then it takes too much time to execute. One sample query is given below:</p>
  
  <pre><code>select * from `ratings` order by id limit 499500, 500
  </code></pre>
  
  <p>Every query takes more than one minute, but when I drop the table to 10 thousand records then this query executes fastly.</p>
  
  <p>As I have read that there is not problem for 1 million records in a table because in database tables, there is not problem of big records.</p>
  
  <p>I have used indexing of id in the table by the help of Stack Overflow question <em><a href="https://stackoverflow.com/questions/3002605/how-to-add-indexes-to-mysql-tables">How do I add indices to MySQL tables?</a></em>, but still I got the same problem.</p>
  
  <p>*** I am using <a href="http://en.wikipedia.org/wiki/Codeigniter#CodeIgniter" rel="nofollow noreferrer">CodeIgniter</a> for the project.</p>