Project

General

Profile

Actions

Patch #21611

closed

Do not collect ids of subtree in Query#project_statement

Patch #21611: Do not collect ids of subtree in Query#project_statement

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

Status:
Closed
Priority:
Normal
Category:
Code cleanup/refactoring
Target version:

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 2 (1 open — 1 closed)

Related to Redmine - Defect #19976: Redmine can't work with 3000 projectsNeeds feedbackActions
Related to Redmine - Feature #19102: Redmine doesnt scale with large amount of projectsClosedActions

Updated by Go MAEDA almost 11 years ago Actions #1

  • Target version set to Candidate for next major release

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

Updated by Go MAEDA almost 11 years ago Actions #2

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

Updated by Go MAEDA almost 11 years ago Actions #3

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

Updated by Jean-Philippe Lang almost 11 years ago Actions #4

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

Updated by Ondřej Ezr almost 11 years ago Actions #5

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

Updated by Go MAEDA almost 11 years ago Actions #6

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

Updated by Toshi MARUYAMA almost 11 years ago Actions #7

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

Updated by Jean-Philippe Lang almost 11 years ago Actions #8

  • 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: PDF Atom