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:

客戶關係
e-Commerce
會計
庫存
PoS
Project
MRP

All apps

所有帖文人獎章

標籤（查看所有）

odoo accounting v14 pos v15

關於此討論區

支援

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

environment odoo12

1 回覆

3927 瀏覽次數

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

作者

thanks! thought so.

喜歡這則討論？不要只閱讀，加入發表意見吧！

今天就建立帳戶，享受獨家功能，與我們精彩的社群互動！

註冊

相關帖文	回覆	瀏覽次數
How can i get odoo environment in thread environment thread odoo12	0 2月 19	5229
Odoo Mail Sending Limit 已解決 odoo12	2 12月 23	14943
(Document type: Invoice, Operation: write) - (Records: [], User: 2) odoo12	0 10月 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 10月 23	790
Remove duplicate record when importing data from excel to Odoo odoo12	1 10月 23	569

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！