#4416 - CPF index management issues

Identifier #4416
Issue type Minor issue (breaks specific functionality)
Title CPF index management issues
Status Completed
Handling member Chris Graham
Version 10.0.33
Addon core
Description There are a number of (mostly) performance issues around CPF index maintenance.

1) Add index last when adding a CPF, in case it times out
2) Automatically delete legacy-named CPF index
3) If changing a CPF field type, delete any indexes that were built for the prior field type
4) Do better index cleanup when deleting a CPF
5) Allow the 'rebuild_all_cpf_indices' helper function to not delete and recreate all CPFs, just create as many missing ones as it can
6) When editing a CPF don't delete and recreate indexes that already exist (involves 2 code changes - in the CPF editing function, and the index adding function - adding an index in general no longer will delete and recreate, repair is now strictly a function of the database structure repair cleanup tool)
Steps to reproduce

Funded? No
Commits

Fixed MANTIS-4416 (CPF index management issues) (7f1b2537) · Commits · Composr ecosystem / Composr · GitLab

The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated