Project

General

Profile

Actions

Bug #7430

closed

User management doing unnecessary joins

Added by krileon about 5 years ago. Updated about 5 years 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.

Actions #2

Updated by krileon about 5 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.

Actions #3

Updated by krileon about 5 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).

Actions #4

Updated by krileon about 5 years ago

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

Fixed in MR !1449

Actions #5

Updated by beat about 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF