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
Akuntansi
Inventaris
PoS
Project
MRP

All apps

Semua Post Orang Lencana-Lencana

Label (Lihat semua)

odoo accounting v14 pos v15

Mengenai forum ini

Help

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

environment odoo12

1 Balas

3903 Tampilan

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

Penulis

thanks! thought so.

Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar

Post Terkait	Replies	Tampilan
How can i get odoo environment in thread environment thread odoo12	0 Feb 19	5207
Odoo Mail Sending Limit Diselesaikan odoo12	2 Des 23	14909
(Document type: Invoice, Operation: write) - (Records: [], User: 2) odoo12	0 Okt 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 Okt 23	789
Remove duplicate record when importing data from excel to Odoo odoo12	1 Okt 23	569

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!