Code Review / cps.git / commit
? search:
summary | shortlog | log | commit | commitdiff | review | tree
(parent: 29b493f) | patch
Add index to schema_set_yang_resources table 72/133572/2
authordanielhanrahan <daniel.hanrahan@est.tech>
Tue, 7 Mar 2023 16:56:08 +0000 (16:56 +0000)
committerDaniel Hanrahan <daniel.hanrahan@est.tech>
Wed, 8 Mar 2023 08:41:15 +0000 (08:41 +0000)
commit38d3064bcb92ed175f2e3b83b10b12c822dfe811
tree53fb7527fb59218a142be242cfe1990a00f3bba8tree | snapshot
parent29b493f8859f1ce0eeadaba75462006499f6f26dcommit | diff
Add index to schema_set_yang_resources table

Currently, the database is sequentially scanning when deleting from
schema_set_yang_resources table as there are no indexes on the table.
Adding an index doubles performance of NCMP CM-handle deregistration.

Issue-ID: CPS-1535
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: Ia6ac7ef95d1662f49a77fc72112f1e29a67079ff
cps-ri/src/main/resources/changelog/changelog-master.yaml diff | blob | history
cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml [new file with mode: 0644] blob
"cps"