Team Members API with large member count takes a long time to load

grafana / grafana

The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.

https://grafana.com

GNU Affero General Public License v3.0

63.89k stars 11.96k forks source link

Team Members API with large member count takes a long time to load #54251

Open timlevett opened 2 years ago

timlevett commented 2 years ago

What happened:

For https://grafana.com/docs/grafana/latest/developers/http_api/team/#get-team-members there is no pagination, we did some load testing and if you have more than 20k users the API takes a very long time to process.

What you expected to happen:

I would expect this API to have pagination much like many other list results have.

How to reproduce it (as minimally and precisely as possible):

Create 21k users
Assign them to a team
Observe slow down in response to get all the members back from running https://grafana.com/docs/grafana/latest/developers/http_api/team/#get-team-members

tolzhabayev commented 1 year ago

https://github.com/grafana/grafana/blob/main/.github/CODEOWNERS#L381

Switching this to AuthNZ squad's board. fyi @grafana/grafana-authnz-team

mgyongyosi commented 1 year ago

Similar solution that has been implemented recently for OrgUsers: https://github.com/grafana/grafana/pull/60896

vtorosyan commented 1 year ago

@alexanderzobnin could you perhaps take a look at this one?

santhoshivan23 commented 1 year ago

Hello @timlevett @alexanderzobnin - I'd like to pick this up if we haven't started efforts on this already. Do lmk.

github-actions[bot] commented 2 months ago

This issue has been automatically marked as stale because it has not had activity in the last year. It will be closed in 30 days if no further activity occurs. Please feel free to leave a comment if you believe the issue is still relevant. Thank you for your contributions!