authgear / authgear/authgear-server
Improve user search performance
Open
cooldown/enhancement
- Dominant language
- Go
- Stars
- 2k
- Forks
- 125
- Avg merge
- 2d 17h
- Merged PRs (30d)
- 32
Description
# Problem
When querying a lot of users from Authgear, e.g. for a user sync job, the resources usage on the DB is very high.
## Solution
Reduce complexity by not encoding pagination in the cursor by default
Contributor guide
Research direction
Start by tracing Authgear’s user search query and cursor pagination implementation, then measure database resource use during a large user sync. Done means pagination is no longer encoded in the cursor by default and large user queries use fewer database resources.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go
- Domain
- authentication, databases, performance
- Issue type
- Refactor
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100