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

Question

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
OR
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 · Answer

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

相关帖文	回复	查看
How can i get odoo environment in thread environment thread odoo12	0 2月 19	5209
Odoo Mail Sending Limit 已解决 odoo12	2 12月 23	14911
(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

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！