Project

General

Profile

Bug #7430

User management doing unnecessary joins

Added by krileon over 1 year ago. Updated over 1 year ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
21 January 2019
Due date:
% Done:

100%

Estimated time:

Description

The count query is joining session and usergroups table unnecessarily. There are other queries in user management that could also use further optimization.

History

#2 Updated by krileon over 1 year 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.

#3 Updated by krileon over 1 year 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).

#4 Updated by krileon over 1 year ago

  • Status changed from Assigned to Resolved
  • % Done changed from 30 to 100

Fixed in MR !1449

#5 Updated by beat over 1 year ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF