Pagination for REST API collections
Bug #1156529 reported by
Peter Holzer
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
GNU Mailman |
Fix Released
|
High
|
Barry Warsaw | ||
Postorius |
Fix Released
|
High
|
Unassigned |
Bug Description
Hi
I'm running a list with roughly 2500 subscribers on mm3 which works like a charm.
Recently I had to manually delete some subscribers and ran into performance issues.
Showing the full list of members takes more than 5 minutes!
I had the naive idea that switching to postgres would change something, it didn't.
The database itself is kind of bored with the request, django instead generates all the cpu load.
I'm not a django-dev and not sure why this rather simple task takes such a long time.
Maybe the easiest was to fix this would be to add a batched listing and a simple search.
Peter
Related branches
lp:~flo-fuchs/mailman/1156529
- Barry Warsaw: Pending requested
-
Diff: 415 lines (+287/-3)8 files modifiedsrc/mailman/rest/docs/lists.rst (+43/-0)
src/mailman/rest/docs/membership.rst (+38/-0)
src/mailman/rest/docs/users.rst (+28/-0)
src/mailman/rest/helpers.py (+41/-0)
src/mailman/rest/lists.py (+4/-1)
src/mailman/rest/members.py (+2/-1)
src/mailman/rest/tests/test_paginate.py (+129/-0)
src/mailman/rest/users.py (+2/-1)
summary: |
- Postorious Performance + Pagination for REST API collections |
tags: | added: mailman3 rest |
Changed in mailman: | |
milestone: | none → 3.0.0b4 |
assignee: | nobody → Barry Warsaw (barry) |
importance: | Undecided → High |
status: | New → In Progress |
Changed in mailman: | |
status: | In Progress → Fix Committed |
Changed in postorius: | |
status: | Confirmed → Fix Committed |
Changed in postorius: | |
milestone: | none → 1.0.0a2 |
Changed in mailman: | |
status: | Fix Committed → Fix Released |
Changed in postorius: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
I just want to say that your bug report kind of made our day here at the PyCon Mailman sprint. We figure you easily have the largest Mailman 3 installation in the world right now.
Florian is working on a solution; we're hoping to have a paginated members page by the end of the week.