Skip to content

NXCALS-3614 faster variables (and hierarchies, and groups)

Kamil Krzysztof Krynicki requested to merge NXCALS-3614-faster-variables into develop

#Merge request template @acc-logging-team - please have a look for approval.

Things I guarantee to be extracted in a single query at this moment:

  • queryAll groups
  • queryAll hierarchies
  • queryAll variables
  • queryAll variables for a hierarchy
  • queryAll entities for a hierarchy

The speedup is noticeable: 80% - 90% faster.

main features

  • CustomRepository now can accept entity graphs for extraction
  • VariableData now exposes entity graphs that are used in VariableService
  • GroupData now exposes entity graphs that are used in GroupService
  • HierarchyData now exposes entity graphs that are used in HierarchyService

secondary features

  • VariableConfig now uses new-style builder structure
  • Variable now uses new-style builder structure
  • VariableConfigData now uses access by field + removed double joins with system + is not comparable
  • VariableData now uses access by field
  • VariableData now stores configs unsorted

minor features

  • removed fake setting system on variable configs from many tests

Closes NXCALS-3614

Edited by Kamil Krzysztof Krynicki

Merge request reports