Code Review / cps.git / commit
? search:
summary | shortlog | log | commit | commitdiff | review | tree
(parent: b3279ee) | patch
Optimize SQL for fetching descendant fragments 60/140560/1
authordanielhanrahan <daniel.hanrahan@est.tech>
Sun, 9 Feb 2025 21:53:34 +0000 (21:53 +0000)
committerdanielhanrahan <daniel.hanrahan@est.tech>
Sun, 23 Mar 2025 12:43:55 +0000 (12:43 +0000)
commitcaefa82d856b21a4b018c175e6ddf808cea69003
treeb897e4265681bc66eece29c895d06211dd6725b0tree | snapshot
parentb3279eefb5ad55054e6098b266686def8367286dcommit | diff
Optimize SQL for fetching descendant fragments

This removes the INNER JOIN from the SQL query, giving
better performance when fetching smaller batches.

Issue-ID: CPS-2712
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: I40ec9b7b54c285cc29fd8188c23eb00b4442c75f
cps-ri/src/main/java/org/onap/cps/ri/repository/FragmentPrefetchRepository.java diff | blob | history
cps-ri/src/main/java/org/onap/cps/ri/repository/FragmentPrefetchRepositoryImpl.java diff | blob | history
"cps"