Project

General

Profile

Actions

Patch #21611

closed

Do not collect ids of subtree in Query#project_statement

Added by Ondřej Ezr almost 9 years ago. Updated almost 9 years ago.

Status:
Closed
Priority:
Normal
Category:
Code cleanup/refactoring
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:

Description

It is inefficient in larger subtree - it would be nicer with pluck, but it would still result in ugly queries with more projects.
Best way is to use subquery in that cases


Files

query_project_statement.diff (1.41 KB) query_project_statement.diff use query not pluck ids Ondřej Ezr, 2015-12-27 19:07
query_project_statement_2.diff (1.5 KB) query_project_statement_2.diff v2 Ondřej Ezr, 2016-01-03 19:45

Related issues

Related to Redmine - Defect #19976: Redmine can't work with 3000 projectsNeeds feedback

Actions
Related to Redmine - Feature #19102: Redmine doesnt scale with large amount of projectsClosed

Actions
Actions

Also available in: Atom PDF