Actions
Bug #7430
closed
User management doing unnecessary joins
Description
The count query is joining session and usergroups table unnecessarily. There are other queries in user management that could also use further optimization.
Updated by krileon almost 6 years ago
- % 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.
Updated by krileon almost 6 years ago
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).
Updated by krileon almost 6 years ago
- Status changed from Assigned to Resolved
- % Done changed from 30 to 100
Fixed in MR !1449
Updated by
Actions