Hi, in DBAPI 3 is there a plan to bring the 'iterable cursor' extension
into the core? Looking at https://wiki.python.org/moin/DbApi3 I couldn't
see anything. The reason I ask is that I'm noticing on PG8000 that the time
taken to execute the warn() for each call to next() is significant for
iterating over a large number of rows.
I'm on the verge of suggesting getting rid of fetchmany() and just having
the iterable, and making execute() return the cursor. Then instead of:
cursor.execute("select * from emp")
all_emps = cursor.fetchmany()
you'd have:
all_emps = [cursor.execute("select * from emp")]
or you could do:
for emp in cursor.execute("select * from emp"):
pass
Cheers,
Tony.
_______________________________________________
DB-SIG maillist - DB-SIG@python.org
https://mail.python.org/mailman/listinfo/db-sig
