Performance Improvement: Filter data tables with property_id
Summary
When applyPOV
is executed, data tables are currently only filtered using the value. However, most of the data is usually unrelated (as it belongs to the wrong properties). Thus, we could introduce an index with property_id and value in it and use the property_id as first condition in the WHERE
clause.
-
create a plan how this can be implemented -
implement the change