Friday, March 29, 2024
1 change · 17.0
Enhancements to existing features
This update improves the speed and efficiency of survey operations by adding database indexes to frequently searched fields. These indexes help the system find survey data faster and reduce unnecessary processing, resulting in quicker response times when users interact with surveys and survey results.
Original PR description
## Description Adding missing indexes to support most of the searches on survey's models to avoid seq.scans and non-selective index scans. Also adding indexes that are inverse to One2many, or dependencies of compute fields (as those if not indexes will trigger a seq.scan when the ORM resolves the dependency tree). If a domain had multiple criteria, only fields with the highest selectivity were indexed. This shall also reduce the amount of tuples returned, reducing IO access and cache trashing. ## Cardinality survey_survey -> X (reference quantity) survey_question -> 10X survey_question_answer -> 50X survey_user_input -> 330X survey_user_input_line -> 7200X ## Reference task-3724844 --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr