8000 Improve user search performance by mparlee · Pull Request #10308 · keycloak/keycloak · GitHub
[go: up one dir, main page]

Skip to content

Improve user search performance - #10308

Merged
hmlnarik merged 1 commit into
keycloak:mainfrom
mparlee:feature/KEYCLOAK-8893-improve-user-search-performance
Mar 4, 2022
Merged

hmlnarik merged 1 commit into
keycloak:mainfrom
mparlee:feature/KEYCLOAK-8893-improve-user-search-performance

Conversation

@mparlee
@mparlee mparlee commented Feb 17, 2022
Copy link
Copy Markdown

Removes bulder.lower() from user search queries on email and username.

Closes #8893

Removes bulder.lower() from user search queries on email and username.

Closes<
8000
/span> keycloak#8893
@mparlee
mparlee commented Feb 17, 2022
Copy link
Copy Markdown
Author

@ahus1

@ahus1 ahus1 self-assigned this Feb 18, 2022
@ahus1
ahus1 self-requested a review February 21, 2022 08:34
@ahus1
ahus1 commented Feb 21, 2022 •
Copy link
Copy Markdown
Member

@hmlnarik - for this first-time contributor, the GitHub actions don't run automatically. Please trigger the GitHub action run for this PR. Thanks!

image

@ahus1 ahus1 added area/storage Storage layer — JPA entities, database schemas, Liquibase migrations, caching team/storage-sig labels Feb 21, 2022
@ahus1
ahus1 commented Feb 21, 2022
Copy link
Copy Markdown
Member

LGTM from code review, did a local test with the UI for exact and wildcard search. Also tested the API as the UI doesn't trigger all code paths. Will defer the approval once I see the CI pass.

@ahus1 ahus1 closed this Mar 2, 2022
@ahus1 ahus1 reopened this Mar 2, 2022
@ahus1
ahus1 commented Mar 2, 2022
Copy link
Copy Markdown
Member

closed and re-opened to re-trigger the builds that were cancelled.

@ahus1 ahus1 left a comment
Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Relevant builds are now green, also tested it manually before (see previous comment).

B15A
@hmlnarik
hmlnarik merged commit 722ce95 into keycloak:main Mar 4, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

area/storage Storage layer — JPA entities, database schemas, Liquibase migrations, caching

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Exact match user query by email is doing a full table scan

3 participants

0