Task #13241

Use CTE (or parent_id keymap) to get the related terms and their ancestors on the search populate task

Added by José Raddaoui Marín about 1 month ago.

Status:NewStart date:01/13/2020
Priority:MediumDue date:
Assignee:-% Done:

0%

Category:Performance / scalability
Target version:-
Google Code Legacy ID: Tested version:
Sponsored:No Requires documentation:

Description

Steve recently improved the process to get the related terms and their ancestors when the archival descriptions are indexed (see #13175). This is a major improvement on the full indexing task but it may not be such on a single description index. AtoM 2.6 will require MySQL 8.0 and we could use CTEs to fetch the terms and ancestors, which may be a better improvement to index a single description.

Either way, the final fix should also be added to the similar query used on the actors index process.


Related issues

Related to Access to Memory (AtoM) - Task #13224: Improve hierarchy management queries Code Review 12/09/2019

History

#1 Updated by José Raddaoui Marín about 1 month ago

  • Related to Task #13224: Improve hierarchy management queries added

Also available in: Atom PDF