Feature proposal #5280
closed
Admin: Improve SQL query efficiency on table filtering
Added by beat over 9 years ago.
Updated over 9 years ago.
Description
In admin area, we join multiple several times same table when searching. This could be a single join per table to optimize the search.
- % Done changed from 0 to 90
Implemented most of it in commit 92b29c748b78f33e2357398d6848b02ea00cfca7
Group search still joins groups-map table a second time, so leaving this open until that is fixed too.
- Status changed from New to Assigned
- Status changed from Assigned to Resolved
- % Done changed from 90 to 100
Implemented in MR !890 . Leaving out user groups filtering for a future rewrite.
- Status changed from Resolved to Closed
Small regression reported and fixed in #5383
Also available in: Atom
PDF
Updated by