Right now we paginate notifications by (notification_timestamp, notification_event), but @SBisson suggests we should instead paginate by notification_event. Event IDs should be in timestamp order anyway. That'll make the pagination logic simpler, and should mean we won't need notification_timestamp in the indexes used for pagination.
Description
Description
Related Objects
Related Objects
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T143963 The Great Echo Database Cleanup of 2016 (and 2019) | |||
| Open | None | T143964 Paginate notifications by event ID, not timestamp |
Event Timeline
Restricted Application added a project: Collaboration-Team-Triage. · View Herald TranscriptAug 26 2016, 1:22 AM2016-08-26 01:22:19 (UTC+0)
• jmatazzoni edited projects, added Collab-Team-Q1-July-Sep-2016; removed Collaboration-Team-Triage.Aug 29 2016, 10:34 PM2016-08-29 22:34:38 (UTC+0)
• jmatazzoni moved this task from Untriaged to Ready for Pickup on the Collab-Team-Q1-July-Sep-2016 board.
• jmatazzoni moved this task from Untriaged to Ready for Pickup on the Collaboration-Team-Triage (Collab-Team-Q2-Oct-Dec-2016) board.Oct 4 2016, 10:50 PM2016-10-04 22:50:50 (UTC+0)
• jmatazzoni edited projects, added Collaboration-Team-Triage; removed Collaboration-Team-Triage (Collab-Team-Q2-Oct-Dec-2016).Nov 3 2016, 12:49 AM2016-11-03 00:49:52 (UTC+0)
Aklapper edited projects, added Growth-Team; removed Collaboration-Team-Triage.Oct 12 2019, 4:08 AM2019-10-12 04:08:43 (UTC+0) ·
MBinder_WMF added a project: Growth-Team-Filtering.Apr 15 2021, 6:59 PM2021-04-15 18:59:30 (UTC+0) ·
Urbanecm_WMF removed projects: Growth-Team-Filtering, Growth-Team.Oct 27 2025, 11:56 PM2025-10-27 23:56:47 (UTC+0) ·