プロジェクト

全般

プロフィール

Vote #81655

未完了

Slow loading of /time_entries/new

Admin Redmine さんが約2年前に追加. 約2年前に更新.

ステータス:
Confirmed
優先度:
通常
担当者:
-
カテゴリ:
Time tracking_13
対象バージョン:
-
開始日:
2022/05/09
期日:
進捗率:

0%

予定工数:
category_id:
13
version_id:
0
issue_org_id:
35927
author_id:
536236
assigned_to_id:
107353
comments:
1
status_id:
9
tracker_id:
1
plus1:
0
affected_version:
closed_on:
affected_version_id:
165
ステータス-->[Confirmed]

説明

Opening /time_entries/new takes 10s, when we have 1000 users with 2 different groups that one has ~10 users and other has all other users.

I have looked into code and it seems I have found the issue, attaching additional info via screens. Basically if project has a lot of users assignable_users enumerates each users permissions by one, creating 2*X (X=number users) sql queries.

I'm hosting redmine with help of docker official image.
Environment:
Redmine version 4.2.1.stable
Ruby version 2.7.4-p191 (2021-07-07) [x86_64-linux]
Rails version 5.2.5
Environment debug
Database adapter SQLServer
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
SCM:
Subversion 1.10.4
Mercurial 4.8.2
Bazaar 2.8.0
Git 2.20.1
Filesystem
Redmine plugins:
no plugin installed


journals

--------------------------------------------------------------------------------

Admin Redmine さんが約2年前に更新

  • カテゴリTime tracking_13 にセット

他の形式にエクスポート: Atom PDF

いいね!0
いいね!0