Project

General

Profile

Actions

Patch #21611

closed

Do not collect ids of subtree in Query#project_statement

Added by Ondřej Ezr over 8 years ago. Updated about 8 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 projectsNeeds feedback

Actions
Actions #1

Updated by Go MAEDA over 8 years ago

  • Target version set to Candidate for next major release

According to #21608#note-3, this patch will resolve #19976 and #19102.

Actions #2

Updated by Go MAEDA over 8 years ago

  • Related to Defect #19976: Redmine can't work with 3000 projects added
Actions #3

Updated by Go MAEDA over 8 years ago

  • Related to Feature #19102: Redmine doesnt scale with large amount of projects added
Actions #4

Updated by Jean-Philippe Lang about 8 years ago

The patch breaks a few tests. It displays issues from subpprojects even if display_subprojects_issues setting is disabled.

Actions #5

Updated by Ondřej Ezr about 8 years ago

I see... I frogot one case in the statement.

Actions #6

Updated by Go MAEDA about 8 years ago

Thanks for updating the patch. It have passed all tests.

Actions #7

Updated by Toshi MARUYAMA about 8 years ago

  • Target version changed from Candidate for next major release to 3.3.0
Actions #8

Updated by Jean-Philippe Lang about 8 years ago

  • Subject changed from Query project_statement - do not collect ids of subtree. to Do not collect ids of subtree in Query#project_statement
  • Category set to Code cleanup/refactoring
  • Status changed from New to Closed
  • Assignee set to Jean-Philippe Lang

Committed, thanks!

Actions

Also available in: Atom PDF