Skip to content

MINTY-7166: Improve speed on view

Wesley Schwengle requested to merge waterkip/zaaksysteem:MINTY-7166-improve_speed_v1_view into master

This changeset adds some caching onto joins that were deemed too expensive to calculate on retrieval. Most importantly, the joins to the zaak_betrokkenen table was extremely costy. This has now been migrated to a db column on zaak (requestor_v1_json, assignee_v1_json and coordinator_v1_json) for the involved bits. This improves the speed quite a lot. Additionally, there isn't a join on case_attributes_v1, this has become a sub-select because it performs better as well.

Signed-off-by: Wesley Schwengle wesley@opndev.io

Closes MINTY-7166

Merge request reports