authgear / authgear/authgear-server

Improve user search performance

Open
#4,300 1 comment 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.