Code Review / cps.git / commit
? search:
summary | shortlog | log | commit | commitdiff | review | tree
(parent: 1450fd0) | patch
Improve performance of deleteDataNodes SQL 47/133347/5
authordanielhanrahan <daniel.hanrahan@est.tech>
Mon, 20 Feb 2023 14:01:45 +0000 (14:01 +0000)
committerdanielhanrahan <daniel.hanrahan@est.tech>
Tue, 21 Feb 2023 21:23:28 +0000 (21:23 +0000)
commit5f91567ed17f96716e7a227702eed2ea96bb9e63
treea651475f6e02a53f86e558b2c5661380fb294c2etree | snapshot
parent1450fd0687433278ce61ae56dfcbf42e0edddce3commit | diff
Improve performance of deleteDataNodes SQL

- Use SQL IN operator instead of temp table when deleting nodes
- Use Postgresql LIKE ANY array operator when deleting lists
- Update delete perf test timings
- Refactor adding cascade delete constraint

Issue-ID: CPS-1502
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: Ic90b867e7c71ec1981f05a9122322ece84dd8bde
cps-ri/src/main/java/org/onap/cps/spi/repository/FragmentNativeRepositoryImpl.java diff | blob | history
cps-ri/src/test/groovy/org/onap/cps/spi/performance/CpsDataPersistenceServiceDeletePerfTest.groovy diff | blob | history
"cps"