title: optimizing SQL execution in Python For loop
body: <p>I'm learning Python and this sqlite3 code is a bit align to me. Is Python going to optimize and run the SQL statement once?</p>
  
  <pre><code>for row in c.execute('SELECT * FROM stocks ORDER BY price'):
      print row
  </code></pre>