9006c10·Author: Ed McDonagh·Closed by: Ed McDonagh·2021-11-23
Description
Added index to modality type in GeneralStudyModuleAttr and the foreign key in GeneralEquipmentModuleAttr - both make RF filter page much faster. Refs #922
Replacing a new count with one that already exists, removing slow query. Refs #922
Replacing a new count with one that already exists, removing slow query (DX). Refs #922
Replacing a new count with one that already exists, removing slow query (MG). Added indexes which massively reduces query time for MG filtered. Refs #922
Replacing a new count with one that already exists, removing slow query (CT). Refs #922
Additional indexes to speed up RF detail page. Refs #922
Additional indexes to speed up RF detail page. Refs #922
Added indexes to all the foreign key relationships, on the assumption that they will improve as the ones that were called in the interface were... Refs #922
Yuck - black wants the indexes to be spread over many lines.... Refs #922
Added index to modality type in GeneralStudyModuleAttr and the foreign key in GeneralEquipmentModuleAttr - both make RF filter page much faster. Refs #922
Replacing a new count with one that already exists, removing slow query. Refs #922
Replacing a new count with one that already exists, removing slow query (DX). Refs #922
Replacing a new count with one that already exists, removing slow query (MG). Added indexes which massively reduces query time for MG filtered. Refs #922
Replacing a new count with one that already exists, removing slow query (CT). Refs #922
Additional indexes to speed up RF detail page. Refs #922
Additional indexes to speed up RF detail page. Refs #922
Indexes to speed up CT detail pages. Refs #922
Index to speed up DX detail pages. Refs #922
Added indexes to all the foreign key relationships, on the assumption that they will improve as the ones that were called in the interface were... Refs #922
Yuck - black wants the indexes to be spread over many lines.... Refs #922
Adding ref #922 to changes.
Â