Defect #42533
open
Bad response time on assigned field
0%
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.
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?
Updated by Eric Diaz 1 day 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