Started to work with SQLite3 in Python3
Chris Angelico
rosuav at gmail.com
Sun Sep 20 12:44:31 EDT 2015
On Mon, Sep 21, 2015 at 1:49 AM, Cecil Westerhof <Cecil at decebal.nl> wrote:
> - I understood that with
> for fuel in fuel_cursor:
> a fetchall will be executed.
> At the moment I do not see this as a problem, but if the table would
> become very big it could. Would it be better to rewrite it with a
> fetchone?
> But that is then needed inside and before the loop. What would be a
> little ugly.
It iterates over the query, but it doesn't fetchall() into a list. So
it's as good as using fetchone().
ChrisA
More information about the Python-list
mailing list