title: Mysql/python fetchall() can't handle result because it is too big
body: <p>I have a table of 2,760,000 rows. In mysqlworkbench, it takes 36 sec to select * from original table. </p>
  
  <p>I want to create another table using this existing table in python (using <strong>my_func()</strong> to convert values).</p>
  
  <p>But, when I run it in the command line, it never seems to finish.</p>
  
  <pre><code>sql = "SELECT ID, Eye, Values FROM my_original_table"
  curQuery.execute(sql)
  
  for row in curQuery.fetchall():        
      dat = list(row)
      id = dat.pop(0)
      eye = dat.pop(0)
      values = dat.pop(0)     
      v = my_func(values)
      if v != None :
          sql = "INSERT INTO new_table VALUES ( '%s', '%s', %d );" % (id, eye, v)
      print(sql)
      curExe.execute(sql)
  
  db.commit()
  </code></pre>
  
  <p>However, if I added <strong>LIMIT 0,10</strong> to my first select sql (like below), it runs fine. So, this means my program is right. But does this mean without the 'Limit', the data is too much for my computer to handle? How can I solve this?</p>
  
  <pre><code>sql = "SELECT ID, Eye, Values FROM ETCEpisodeVisualAcuity LIMIT 0,10"
  </code></pre>