Project

General

Profile

Actions
Copy link

Feature #36696

closed

Improve performance of adding or removing members of a group

Added by James H over 2 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Go MAEDA
Category:
Performance
Target version:
5.0.0
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed

Description

In situations where groups are applied to hundreds of projects (with or without subprojects, with or without inherit members), adding or removing a user from the group takes VERY LONG (more than 5-10 minutes).

Would like to request:
  1. Better querying optimization?
  2. Bulk edit capability

1. not sure how because I do not know how it queries. maybe something like consolidate multiple queries into fewer big queries?
2. When looking at the "users" tab under Groups, have a checkmark selection and "Apply All" button at the bottom for actions applied for multiple users at once. This way it can try to optimize the query for that?

Files

Download all files
36696.patch (2.87 KB) 36696.patch Go MAEDA, 2022-02-28 08:56
36696-v2.patch (3.42 KB) 36696-v2.patch Go MAEDA, 2022-02-28 16:25

Related issues

Related to Redmine - Patch #36730: Replace Member.find_or_new with ActiveRecord's find_or_initialize_byClosedGo MAEDA

Actions
Actions
Copy link

Also available in: Atom PDF