Speed up client and authorization lookup with database indexes #12

Manually merged
ansv7779 merged 1 commits from slow-login into main 2026-02-18 15:34:48 +01:00
Owner

During a normal OIDC login workflow (authentication/consent, code exchange, and user info lookup), that results in SQL queries filtering on columns that are now indexed. Before it used to table scan which was extremely slow.

During a normal OIDC login workflow (authentication/consent, code exchange, and user info lookup), that results in SQL queries filtering on columns that are now indexed. Before it used to table scan which was extremely slow.
ansv7779 added 1 commit 2026-01-13 14:53:38 +01:00
Speed up client and authorization lookup with database indexes
All checks were successful
/ build (push) Successful in 3m28s
6c2f90774d
During a normal OIDC login workflow (authentication/consent, code exchange, and user info lookup), that results in SQL queries filtering on columns that are now indexed. Before it used to table scan which was extremely slow.
ansv7779 requested review from stne3960 2026-02-18 12:44:17 +01:00
stne3960 approved these changes 2026-02-18 13:11:13 +01:00
stne3960 left a comment
Owner

Looks very reasonable 👍

Looks very reasonable 👍
ansv7779 manually merged commit a74f354830 into main 2026-02-18 15:34:48 +01:00
ansv7779 deleted branch slow-login 2026-02-18 15:34:54 +01:00
Sign in to join this conversation.
No Reviewers
No Label
No Milestone
No project
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: DMC/oauth2-authorization-server#12
No description provided.