Spike: Investigate performance issues when loading UI identities

Open emyller opened this issue 5 months ago • 2 comments

API endpoint: /api/v1/environments/<environment_api_key>/identities/

For environments with millions of identities, it can be very slow to load the UI, even while it's paginated.

Possibly this sorting could benefit from a binary tree index on Identity.created_date exclusively. This spike is to coordinate an investigation and confirm this is the case, or point somewhere else.

Oct 10 '25 18:10 emyller

Hey @emyller, I'd love to take up this issue and investigate the performance aspect mentioned here. Could you please assign it to me?

Oct 13 '25 12:10 Aaditya1273

@Aaditya1273 Done! I'm sorry it took me long, I was off the grid on holidays and just caught up to this. We understand if this no longer fits your agenda! Please let me know if you're still keen to take this one.

Oct 30 '25 20:10 emyller