What is faster, creating a env every time in a loop or to create a variable and use it?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Comptabilité
Inventaire
PoS
Project
MRP

All apps

Toutes les publications Personnes Badges

Étiquettes (Voir toutl)

odoo accounting v14 pos v15

À propos de ce forum

Aide

What is faster, creating a env every time in a loop or to create a variable and use it?

environment odoo12

1 Répondre

3717 Vues

Samo Arko

I'm wondering what is faster or is there no difference between

for rec in self:
    partner = rec.env['res.partner'].search() # or any other orm method

partner_env = self.env['res.partner']
for rec in self:
    partner = partner_env.search() # or any other orm method

I'm creating a sync with Odoo from other older custom CRM/ERPs and the sync has to go trough 100+, 1000+ or even 10000+ records. So every small performance boost helps.

So what method is faster and why?

Paresh Wagh

Hi Samo:

The 2nd option (using a variable) will be marginally faster because the recordset is built once and reused inside the loop.

Samo Arko

Auteur

thanks! thought so.

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !

Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !

S'inscrire

Publications associées	Réponses	Vues
How can i get odoo environment in thread environment thread odoo12	0 févr. 19	4975
Odoo Mail Sending Limit Résolu odoo12	2 déc. 23	14535
(Document type: Invoice, Operation: write) - (Records: [], User: 2) odoo12	0 oct. 23	33
Error while importing data in Odoo12: An unknown issue occurred during import (possibly lost connection, data limit exceeded or memory limits exceeded) odoo12	3 oct. 23	788
Remove duplicate record when importing data from excel to Odoo odoo12	1 oct. 23	569

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !