title: Loading 5 million rows into Pandas from MySQL
body: <p>I have 5 million rows in a MySQL DB sitting over the (local) network (so quick connection, not on the internet).</p>
  
  <p>The connection to the DB works fine, but if I try to do </p>
  
  <pre><code>f = pd.read_sql_query('SELECT * FROM mytable', engine, index_col = 'ID')
  </code></pre>
  
  <p>This takes a <em>really</em> long time. Even chunking with <code>chunksize</code> will be slow. Besides, I don't really know whether it's just hung there or indeed retrieving information.</p>
  
  <p>I would like to ask, for those people working with large data on a DB, how they retrieve their data for their Pandas session?</p>
  
  <p>Would it be "smarter", for example, to run the query, return a csv file with the results and load <strong>that</strong> into Pandas? Sounds much more involved than it needs to be.</p>