Project

General

Profile

Actions

Patch #43214

closed

Optimize Project.allowed_to_condition by replacing `projects.status <> ...` with `projects.status IN (...)`

Added by Go MAEDA 2 days ago. Updated 2 days ago.

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

0%

Estimated time:

Description

The attached patch replaces the condition projects.status <> ... with the equivalent projects.status IN (...) in the Project.allowed_to_condition method.

This change makes the SQL clearer and may improve performance, since IN (...) is generally more optimizer-friendly than a combination of <> conditions. A performance benefit of this approach was also observed during the investigation of #40728 (see #40728#note-15 and #40728#note-16).


Files


Related issues

Related to Redmine - Feature #36691: Background job and dedicated status for project deletionClosedMarius BĂLTEANU

Actions
Actions

Also available in: Atom PDF