[9.0] mis_builder - Tips for performance optimization?

[JordiBForgeFlow]

Hi!

I am using plenty of KPI's using syntax like bale[][('account_id.tag_ids.name','=', '14300 Inventory')], but with quite a lot of history this seems to be a performance killer. @sbidoul do you have any recommendation based on your experience? Perhaps a better way to query based on account tags, or perhaps we need to add indices to the DB?

[JordiBForgeFlow]

cc @lreficent

[sbidoul]

bale[('tag_ids.name','=', '14300 Inventory')] should be much snappier :)

Everything that is done with the account filter is processed with a single query to database. When you do move line filters, then there is one query per filter.

[sbidoul]

These extended account selectors were added as a new feature in mis builder 3.1.

[JordiBForgeFlow]

[JordiBForgeFlow]

@sbidoul Well that just made my week!! Thank you very much for the tip!

[sbidoul]

My pleasure :)