Redmine

Hello,

We recently upgraded our Redmine instance from version 4.1.3 to 5.1.4 and noticed a significant increase in response time when opening the "Spent Time" tab. It is important to mention that our project contains multiple subprojects, with a total of over 35,000 issues.

In the previous version (4.1.3), the response time for opening this tab was just a few seconds:

However, in the new version (5.1.4), the response time exceeds 10 seconds:

Our Redmine usage heavily relies on these reports, and these delays considerably impact the user experience.

Below, I am providing the technical details of our servers and system:

DB:

mysql  Ver 8.4.3-3 for Linux on x86_64 (Percona Server (GPL), Release 3, Revision 505340da) 
Red Hat Enterprise Linux 9.5

System:

Environment:
  Redmine version                5.1.4.stable
  Ruby version                   3.2.6-p234 (2024-10-30) [x86_64-linux]
  Rails version                  6.1.7.10
  Environment                    production
  Database adapter               Mysql2
  Mailer queue                   ActiveJob::QueueAdapters::AsyncAdapter
  Mailer delivery                smtp
Redmine settings:
  Redmine theme                  Default
SCM:
  Subversion                     1.14.2
  Mercurial                      6.3.2
  Bazaar                         3.3.2
  Git                            2.39.5
  Filesystem                     
Redmine plugins:
  additional_tags                3.4.0
  additionals                    3.4.0
  redmica_s3                     2.2.0
  redmine_agile                  1.6.9
  redmine_contacts               4.4.1
  redmine_contacts_helpdesk      4.2.4
  redmine_dark                   1.0.2
  redmine_indicator              0.2.16
  redmine_issue_dynamic_edit     0.9.2
  redmine_issue_templates        1.2.1
  redmine_mentions               0.0.1
  redmine_messenger              1.0.14
  redmine_oauth                  2.2.8
  redmine_reporting              3.4.0

Thank you very much!