https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292021-05-03T20:27:46ZRedmineRedmine - Defect #35192: Watchers pop up window appears after a long timehttps://www.redmine.org/issues/35192?journal_id=1023272021-05-03T20:27:46ZMarius BĂLTEANU
<ul><li><strong>Assignee</strong> set to <i>Marius BĂLTEANU</i></li></ul> Redmine - Defect #35192: Watchers pop up window appears after a long timehttps://www.redmine.org/issues/35192?journal_id=1023312021-05-03T21:15:57ZMarius BĂLTEANU
<ul><li><strong>Related to</strong> <i><a class="issue tracker-3 status-5 priority-4 priority-default closed" href="/issues/33329">Patch #33329</a>: Improve watchers functionality to mark the users that are watching a non visible object and to not return watchers that cannot see the object</i> added</li></ul> Redmine - Defect #35192: Watchers pop up window appears after a long timehttps://www.redmine.org/issues/35192?journal_id=1023332021-05-03T21:21:12ZMarius BĂLTEANU
<ul></ul><p>How many members do you have on the project where you experience this issue? (rounded number).</p>
<p>In <a class="issue tracker-3 status-5 priority-4 priority-default closed" title="Patch: Improve watchers functionality to mark the users that are watching a non visible object and to no... (Closed)" href="https://www.redmine.org/issues/33329">#33329</a>, I've proposed two options (4 and 5) to avoid this performance issue, which one works better for you?</p> Redmine - Defect #35192: Watchers pop up window appears after a long timehttps://www.redmine.org/issues/35192?journal_id=1023362021-05-04T06:56:24ZJean-René ROUET
<ul></ul><p>Hi</p>
<p>when it took 10 seconds to pop up, there is 900 members.<br />when it took 25 seconds, there is 2500 members.<br />it's linear</p>
<p>I prefer the option 4</p> Redmine - Defect #35192: Watchers pop up window appears after a long timehttps://www.redmine.org/issues/35192?journal_id=1065592022-04-29T07:32:48ZSimon Hori
<ul></ul><p>Hello Marius,</p>
<p>Thank you for the patch <a class="issue tracker-3 status-5 priority-4 priority-default closed" title="Patch: Improve watchers functionality to mark the users that are watching a non visible object and to no... (Closed)" href="https://www.redmine.org/issues/33329">#33329</a> that is good improvement for sure.<br />But we do have the same perfomance problem with 1300+ users.<br /><pre>watchable_object.visible?(user)</pre> is making at least two SQL queries per user.</p>
<p>I don't think we need all users names listed when the search query is <strong>blank</strong>. so I would like to request <strong>option 4</strong>.</p>
<p>As a test, I made this change and it reduced loading time from 4 sec to 0.2 sec.</p>
<pre><code class="diff syntaxhl"><span class="gd">- scope = @project.principals.assignable_watchers
</span><span class="gi">+ scope = @project.principals.assignable_watchers.limit(100)
</span></code></pre> Redmine - Defect #35192: Watchers pop up window appears after a long timehttps://www.redmine.org/issues/35192?journal_id=1082772022-10-20T14:44:44ZBenoît Yegre
<ul></ul><p>Hello</p>
<p>We have the same problem that watchers pop up window appears after a long time.</p>
<p>Config :</p>
<pre>
Environment:
Redmine version 4.2.8.stable
Ruby version 2.7.6-p219 (2022-04-12) [x86_64-linux]
Rails version 5.2.8.1
Environment production
Database adapter PostgreSQL
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
SCM:
Subversion 1.14.1
Mercurial 5.6.1
Bazaar 3.1.0
Git 2.30.2
Filesystem
Redmine plugins:
redmine_openid_connect 0.9.4
</pre>
<p>We have 3 000 users and when we want add watchers for an issue, it takes a while to appear the watchers box (20 seconds).</p>
<p>Is there a solution ?<br /> - like limiting watchers for a project ...</p>
<p>Thank you for your help.</p> Redmine - Defect #35192: Watchers pop up window appears after a long timehttps://www.redmine.org/issues/35192?journal_id=1105162023-08-09T10:59:24ZGuillermo ML
<ul></ul><p>We have hit the same performance problems.<br />We have a project with 1125 members, it takes ~4s to show the windows and another ~3 to see the watcher added.<br />On projects with few users the action is almost immediate.</p>
<p><a href="#" onclick="$('#collapse-ba6a1d40-show, #collapse-ba6a1d40-hide').toggle(); $('#collapse-ba6a1d40').fadeToggle(150);; return false;" id="collapse-ba6a1d40-show" class="icon icon-collapsed collapsible">Our configuration</a><a href="#" onclick="$('#collapse-ba6a1d40-show, #collapse-ba6a1d40-hide').toggle(); $('#collapse-ba6a1d40').fadeToggle(150);; return false;" id="collapse-ba6a1d40-hide" class="icon icon-expended collapsible" style="display:none;">Our configuration</a><div id="collapse-ba6a1d40" class="collapsed-text" style="display:none;"><pre>
Environment:
Redmine version 5.0.5.stable
Ruby version 2.7.6-p219 (2022-04-12) [x86_64-linux]
Rails version 6.1.7.2
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
Redmine settings:
Redmine theme Purplemine2-2.14.0
SCM:
Subversion 1.10.2
Mercurial 4.8.2
Git 2.31.1
Filesystem
Gitlab 4.14.0
Redmine plugins:
redmine_agile 1.6.5
redmine_gitlab_adapter 0.2.1
view_customize 3.3.0
</pre></div></p>