Improve performance when sorting namespaces by created_at and updated_at column
There's an ongoing performance issues when sorting namespaces by created_at or updated_at column due to the lack of database indexes. This issue is focused on identifying solutions around this restriction.
We cannot directly add these because the namespaces table already exceeds the 15 maximum index limit.
Possible Solutions
No particular ordering. These needs further evaluation.
- Delegate the sorting column to
namespace_details.created_atandnamespace_details.updated_at - Move other
namespacestable columns with an index to other tables. Providing room for these indices (source)
Checklist (Acceptance Criteria)
-
Performant sorting by
created_atandupdated_atin https://gitlab.com/explore/groups -
The
idsorting column proxy onExplore > Groupspage must be returned tocreated(!229238 (merged))
Edited by Shane Maglangit