Bug #7430
closed
User management doing unnecessary joins
Added by krileon almost 6 years ago.
Updated over 5 years ago.
Start date:
21 January 2019
Description
The count query is joining session and usergroups table unnecessarily. There are other queries in user management that could also use further optimization.
- % Done changed from 0 to 30
Appears to just be the unnecessary client id filter being applied to the _sessions join as it's causing a nested loop since it's using IN. Removing it significantly improves the query performance as it's no longer a nested loop and can utilize its index. The filter isn't necessary either.
session and usergroup_map join still slowing significantly (around 400ms on a 100k user table) when they aren't being filtered (so there's no reason to join them).
- Status changed from Assigned to Resolved
- % Done changed from 30 to 100
- Status changed from Resolved to Closed
Also available in: Atom
PDF
Updated by 
Updated by