unkey icon indicating copy to clipboard operation
unkey copied to clipboard

List identeties does n+1

Open Flo4604 opened this issue 2 months ago • 1 comments

Currently when listing identeties it takes a long time because for each identity we select ratelimits in a seperate query.

This should be done using json_arrayagg in the list identities query instead.

  • [ ] Select ratelimits by joining the data in the db.Query.ListIdentities query
  • [ ] Remove db.Query.ListIdentityRatelimits n+1

Flo4604 avatar Oct 23 '25 20:10 Flo4604

ENG-2142

linear[bot] avatar Oct 23 '25 20:10 linear[bot]