View Issue Details

IDProjectCategoryView StatusLast Update
0032796mantisbtperformancepublic2023-08-23 12:49
ReporterfAtsteD Assigned Tocommunity  
PrioritynormalSeverityminorReproducibilityalways
Status assignedResolutionopen 
Product Version2.25.6 
Summary0032796: Long load for all projects for administrator (thousands projects active)
Description

The system has thousands of projects with less than 50 bugs for each project. All projects stay in the tree.

Steps To Reproduce
  1. Generate thousands of projects in the tree with a minimum of 3 levels deep.
  2. Activate all projects, and log in with administrator privileges.
  3. Open the page with all bugs.
TagsNo tags attached.

Relationships

has duplicate 0032790 closeddregad Taking more than 2 minutes on all projects 

Activities

atrol

atrol

2023-07-30 10:35

developer   ~0067943

Are you still able to reproduce after upgrading to latest stable version 2.25.7?
There are some improvements in it when having many projects, see 0032131

fAtsteD

fAtsteD

2023-07-30 14:12

reporter   ~0067944

Test 2.25.7 and it does not help.

I know where the problem, it builds of the project tree. It builds every time for calling function, so I have many times while the server builds the project tree for one request of page.
The subfunction cache data from the database but the main for building the project tree does not do.

I create a pull request later.

atrol

atrol

2023-07-30 15:56

developer   ~0067946

PR https://github.com/mantisbt/mantisbt/pull/1900

dregad

dregad

2023-08-23 12:49

developer   ~0068009

@nhchoudhary please have a look a the discussion in https://github.com/mantisbt/mantisbt/pull/1900.

I'm reluctant to merge it as-is, because I am not able to reproduce the original performance issue and therefore can't properly review and test the updated code.

Since you mentioned in 0032790 that you faced the same issue and the proposed fix did improve things for you, maybe you would be able to provide a reproducible test case that I could look at and use for tests.

Your feedback, here or directly in the pull request, would be appreciated.