[RFC] performances issues on product_multi_company used on huge database about multi-company HOT 7 CLOSED

@pedrobaeza @lmignon @Cedric-Pigeon there is a better solution I think. We can optimize the search for company_ids=False if we have a stored flag 'visible_for_all_companies' that is set to True when company_ids is empty, and use it in the record rule.

from multi-company.

@sbidoul @lmignon

from multi-company.

Can auto_join help?

from multi-company.

@pedrobaeza The problem seems to be related to odoo/odoo#26702
company_ids is already declared with auto_join=True

from multi-company.

OK, I see. Then it's OK to go to that patch. It's similar to the parent_left/parent_right deprecation done on master.

from multi-company.

OK, that can be another solution that seems cleaner.

from multi-company.

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.

from multi-company.