summaryrefslogtreecommitdiff
path: root/releasenotes/notes/change-db-access-pattern-for-node-lists-a333dd9c5afa737d.yaml
blob: 3d91f62314dbafc4b1308feb49868f830f7c03e1 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
---
upgrade:
  - |
    The query pattern for the database when lists of nodes are retrieved has
    been changed to a more efficient pattern at scale, where a list of nodes
    is generated, and then additional queries are executed to composite this
    data together. This is from a model where the database client in the
    conductor was having to deduplicate the resulting data set which is
    overall less efficent.
other:
  - |
    The default database query pattern has been changed which will result
    in additional database queries when compositing lists of ``nodes``
    by separately querying ``traits`` and ``tags``. Previously this was a
    joined query which requires deduplication of the result set before
    building composite objects.