title: How to select large amount of data in mysql?
body: <p>I have a table mysql with 70 million records. I want to search something on this but my method spent too much time . I want to reduce it. how to reduce the time select (search a record)? </p>
  
  <p>My table structure: </p>
  
  <pre><code>Member
  ID || Username || Fullname
  70 million records
  </code></pre>
  
  <p>My sql query :</p>
  
  <pre><code>     "Select Fullname from Member where ID=id"
  </code></pre>