Feature proposal #5280
closed
Admin: Improve SQL query efficiency on table filtering
Added by beat about 10 years ago.
Updated almost 10 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