title: How to improve the performance of MYSQL query with large data?
body: <p>I am using <code>MySQL</code> tables that have the following data:</p>
  
  <pre><code>users(ID, name, email, create_added) (about 10000 rows)
  points(user_id, point) (about 15000 rows)
  </code></pre>
  
  <p>And my query:</p>
  
  <pre><code>SELECT u.*, SUM(p.point) point 
  FROM users u 
  LEFT JOIN points p ON p.user_id = u.ID 
  WHERE u.id &gt; 0 
  GROUP BY u.id 
  ORDER BY point DESC 
  LIMIT 0, 10
  </code></pre>
  
  <p>I only get the top 10 users having best point, but then it dies. How can I improve the performance of my query?</p>