Actions
Patch #43214
closedOptimize Project.allowed_to_condition by replacing `projects.status <> ...` with `projects.status IN (...)`
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
Actions