summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authordanielhanrahan <daniel.hanrahan@est.tech>2023-03-07 16:56:08 +0000
committerDaniel Hanrahan <daniel.hanrahan@est.tech>2023-03-08 08:41:15 +0000
commit38d3064bcb92ed175f2e3b83b10b12c822dfe811 (patch)
tree53fb7527fb59218a142be242cfe1990a00f3bba8
parent29b493f8859f1ce0eeadaba75462006499f6f26d (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
-rw-r--r--cps-ri/src/main/resources/changelog/changelog-master.yaml6
-rw-r--r--cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml15
2 files changed, 19 insertions, 2 deletions
diff --git a/cps-ri/src/main/resources/changelog/changelog-master.yaml b/cps-ri/src/main/resources/changelog/changelog-master.yaml
index cb5392ba57..43a54caf64 100644
--- a/cps-ri/src/main/resources/changelog/changelog-master.yaml
+++ b/cps-ri/src/main/resources/changelog/changelog-master.yaml
@@ -1,6 +1,6 @@
# ============LICENSE_START=======================================================
# Copyright (c) 2021 Bell Canada.
-# Modifications Copyright (C) 2022 Nordix Foundation.
+# Modifications Copyright (C) 2022-2023 Nordix Foundation.
# ================================================================================
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
@@ -47,4 +47,6 @@ databaseChangeLog:
- include:
file: changelog/db/changes/15-rename-column-yang-resource-table.yaml
- include:
- file: changelog/db/changes/16-insert-cm-handle-state.yaml \ No newline at end of file
+ file: changelog/db/changes/16-insert-cm-handle-state.yaml
+ - include:
+ file: changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml
diff --git a/cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml b/cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml
new file mode 100644
index 0000000000..bc16725109
--- /dev/null
+++ b/cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml
@@ -0,0 +1,15 @@
+databaseChangeLog:
+ - changeSet:
+ author: cps
+ id: 17
+ changes:
+ - createIndex:
+ columns:
+ - column:
+ name: schema_set_id
+ indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK
+ tableName: schema_set_yang_resources
+ rollback:
+ - dropIndex:
+ indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK
+ tableName: schema_set_yang_resources