Project

General

Profile

Actions

Defect #42533

open

Bad response time on assigned field

Added by Eric Diaz about 2 months ago. Updated about 21 hours ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Issues filter
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Affected version:

Description

Hi all

My environnement

Environment:
Redmine version 4.2.6.stable
Ruby version 2.7.6-p219 (2022-04-12) [x86_64-linux]
Rails version 5.2.8
Environment production
Database adapter PostgreSQL
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
SCM:
Subversion 1.10.2
Git 2.31.1
Filesystem
GitRemote 2.31.1
Redmine plugins:
redmine_agile 1.6.4
redmine_banner 0.3.4
redmine_checklists 3.1.21
redmine_git_remote 0.0.2
redmine_issue_templates 1.1.0
redmine_passerelle_cap2 1.1.0
redmine_webhook 1.0.1
view_customize 3.4.0

On one of my projects, I have 2630 members
When a user add a fliter based onAssigned_to_id in a custom report, it takes between 30 and 60 seconds to load the field.
It happens on Firefox and it is a little more fast on IE but still too slow.

Is it related to my redmine version or the root cause can be eslewhere ?
I check on database, everything is good, no overlay.
It seems the navigator has difficulties to absorp the amount of data.
It was not the same on version 3.3 we had before.

Actions #1

Updated by Go MAEDA about 1 month ago

I tested this on my development environment using Redmine 6.0. I added 3000 members to a single project and tried adding the "Assigned to" filter on the Issues page. It only took 2–3 seconds to load.

Since Redmine 4.2 is an old version and no longer supported, could you try updating to the latest Redmine 6.0 to see if the issue still occurs?

Actions #2

Updated by Eric Diaz about 1 month ago

OK I'll try. Thanks for the test

Actions #3

Updated by Eric Diaz about 21 hours ago

Update.
after further investigations, it appears that it is a javascript issue.
Every items of lists are load on "var availableFilters" then JQUERY creates Option menu.

The "var availableFilters" is very big (more than 500 000 characters)
This is the root cause of the delay

Actions

Also available in: Atom PDF