Repository navigation
Optimization of loadUserSessionsWithClientSessions method #11779
ArmanGhost
started this conversation in
Ideas
Replies: 2 comments
|
The current query filters within a range of UUIDs and can load an indefinite number of records. It seems very odd. Is there any good reason to do so ? |
8000
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
We have a problem with getting of all user offline sessions in out SPI. After code inspection we found that part of code
For example, if you need to get two user offline sessions you need to select all offline client sessions beetween them. And in our case it can be 100 000 of them. Our keycloak is crashed vecause of that.
After we disable getting offline user profiles, our problem is solved, but we need this
URL of this commit:
919899b
@hmlnarik and @pfstrifork can you help us with this?
We changed a code to last version (before some changes that which led to this non optimization query)
All reactions