Use id as proxy sorting column for created_at in Explore > Groups
What does this MR do and why?
Use id as the column used to sort by creation date on Explore > Groups (Vue) page. This is necessary to unblock the rollout for the frontend changes while we look for ways to fix the performance issues with the created_at column.
- We have an existing recommendation to use
order_by idoverorder_by created_atwhen possible. The potential inaccuracy outweighs the performance boost.- As noted in the docs: there is rarely a case where the user actually cares about the difference between these 2 columns.
- The accuracy of creation date is not important in this page.
- There's still a long way for the Cells architecture. The warning won't take effect for a long time.
- We have prior attempts to add the missing index for these columns but were pushed back due to the number of existing index in the
namespacestable.
References
- Related Issue: Improve performance when sorting namespaces by ... (#588691)
- Closes #595016 (closed)
Screenshots or screen recordings
| Descending | Ascending |
|---|---|
![]() |
![]() |
How to set up and validate locally
- Enable the
explore_groups_vuefeature flag - Go to http://localhost:3000/explore/groups
MR acceptance checklist
Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Edited by Shane Maglangit

