Replace fetchall by iteration
In #4949 (closed), one of the goal of the change was to replace .fetchall by iteration over the cursor.
Indeed for psycopg2, it will only safe the list creation in memory because psycopg2 fetchall the data any way (except if we use named cursor).
Any way, it is still good to iterate over the cursor instead of .fetchall if the resulted list is never stored.
Activity
added type::performance + 1 deleted label
added easy label
assigned to @ced
review335831003 updated at https://codereview.tryton.org/335831003/#ps347931003
New changeset 25fa27914f88 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/account/rev/25fa27914f88New changeset 8c2c281a6531 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/account_deposit/rev/8c2c281a6531New changeset cce84836da4f by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/account_dunning/rev/cce84836da4fNew changeset ea055cc5009b by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/account_invoice/rev/ea055cc5009bNew changeset 13c9be5bfcaf by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/account_payment_sepa/rev/13c9be5bfcafNew changeset 4fa6fd2e3dda by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/account_statement/rev/4fa6fd2e3ddaNew changeset 13e879e38c1c by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/analytic_account/rev/13e879e38c1cNew changeset 945ba1baf73e by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/commission/rev/945ba1baf73eNew changeset 95c963bbe219 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/currency/rev/95c963bbe219New changeset 877a827c069c by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/marketing_automation/rev/877a827c069cNew changeset 508fd56d0ae5 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/party/rev/508fd56d0ae5New changeset 20ebbd9e622b by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/project/rev/20ebbd9e622bNew changeset d84bce053fd2 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/project_invoice/rev/d84bce053fd2New changeset 45199a288fba by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/project_revenue/rev/45199a288fbaNew changeset 49aa55971c23 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/purchase/rev/49aa55971c23New changeset 81aca820f1d0 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/sale/rev/81aca820f1d0New changeset 09b8cbde96ac by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/sale_extra/rev/09b8cbde96acNew changeset 4cbadd5f1466 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/sale_opportunity/rev/4cbadd5f1466New changeset 624ad590a7cf by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/sale_promotion_coupon/rev/624ad590a7cfNew changeset 84dc1a0ab574 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/stock/rev/84dc1a0ab574New changeset 098d44db530e by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/stock_forecast/rev/098d44db530eNew changeset d5bd5090b474 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/timesheet/rev/d5bd5090b474New changeset 089a4aeb7c89 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/timesheet_cost/rev/089a4aeb7c89New changeset 0dfd9ab91045 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/modules/web_shortener/rev/0dfd9ab91045New changeset 130d98839af1 by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/trytond/rev/130d98839af1New changeset e0e9bff953ca by Cédric Krier in branch 'default':
Replace cursor fetchall by iteration over cursor
https://hg.tryton.org/tryton-env/rev/e0e9bff953camentioned in issue #10148
