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