Read Performance Improvement - Using Native Query 07/131607/10
authorToineSiebelink <toine.siebelink@est.tech>
Thu, 20 Oct 2022 17:34:29 +0000 (18:34 +0100)
committerToine Siebelink <toine.siebelink@est.tech>
Thu, 27 Oct 2022 10:52:56 +0000 (10:52 +0000)
commita096a7faa35b345c765102201a5a09cc03ef541a
treebcf99d79138ef5f15e681a564ff655da44f26a5a
parent321d969c11826ccc3a01f6002cfaae2d0a5a4f9d
Read Performance Improvement - Using Native Query

- Native query for FragmentExtracts
- Convert FragmentExtracts to tree of FragmentEntity
- Native Query now used for all Gets with descendants (orignal hibernate option only used when descendanst ommited)
- Added error handling for not-found on native query
- Ommit descendants by default on many udpate use-cases (this might have a signifcant perf. improvemnt impact too)
- Improved legacy tests for delete use-cases
- Corrected performace test expectation
- Fix TTL test realizing TTL resolution is whole seconds!

Issue-ID: CPS-1301
Signed-off-by: ToineSiebelink <toine.siebelink@est.tech>
Change-Id: I658ac1b7b7036f01050f30bdf9e5bd175725ef1d
cps-ncmp-service/src/test/groovy/org/onap/cps/ncmp/api/impl/config/embeddedcache/SynchronizationCacheConfigSpec.groovy
cps-ri/src/main/java/org/onap/cps/spi/entities/FragmentEntityArranger.java [new file with mode: 0644]
cps-ri/src/main/java/org/onap/cps/spi/entities/FragmentExtract.java [new file with mode: 0644]
cps-ri/src/main/java/org/onap/cps/spi/impl/CpsDataPersistenceServiceImpl.java
cps-ri/src/main/java/org/onap/cps/spi/repository/FragmentRepository.java
cps-ri/src/main/java/org/onap/cps/spi/repository/FragmentRepositoryCpsPathQueryImpl.java
cps-ri/src/test/groovy/org/onap/cps/spi/impl/CpsDataPersistenceServiceIntegrationSpec.groovy
cps-ri/src/test/groovy/org/onap/cps/spi/impl/CpsDataPersistenceServiceSpec.groovy
cps-ri/src/test/groovy/org/onap/cps/spi/impl/CpsToDataNodePerfSpec.groovy
cps-ri/src/test/resources/application.yml
cps-service/src/main/java/org/onap/cps/spi/CpsDataPersistenceService.java