-
Bug
-
Resolution: Done
-
Major
-
None
-
None
-
False
-
None
-
False
-
-
-
-
-
-
-
Running a performance benchmark with Keycloak, originated the following statistics for indexed queries.
The hybrid query max duration is 521'324'713'458'648 nanoseconds, which is way too high. The maximum response time in the benchmark was 58ms.
"indexed_local" : { "count" : 14000, "average" : 1461806.270357143, "max" : 18572555, "slowest" : "DELETE FROM keycloak.RemoteAuthenticatedClientSessionEntity WHERE (userSessionId = :p0)" }, "indexed_distributed" : { "count" : 21000, "average" : 1160159.8945238094, "max" : 38768261, "slowest" : "DELETE FROM keycloak.RemoteAuthenticatedClientSessionEntity WHERE (userSessionId = :p0)" }, "hybrid" : { "count" : 7000, "average" : 5.212894825635777E14, "max" : 521324713458648, "slowest" : "SELECT __HSearch_This, __ISPN_Version FROM keycloak.RemoteAuthenticatedClientSessionEntity" },
- clones
-
ISPN-16481 Hybrid remote queries statistics seem incorrect
- Resolved