Defect #37268
Updated by Holger Just about 1 month ago
With r21646 especially this change: https://www.redmine.org/projects/redmine/repository/revisions/21646/diff/trunk/app/models/issue_custom_field.rb
<pre><code class="ruby">
"((#{sql}) AND (#{tracker_condition}) AND (#{project_condition}))"
</code></pre> </pre>
to
<pre><code class="ruby">
"((#{sql}) AND (#{tracker_condition}) AND (#{project_condition}) AND (#{Issue.visible_condition(user)}))"
</code></pre> </pre>
we got massive performance problems on issue list.
Some information to the system environment:
* Redmine 5.0.2 (for this issue I selected 5.0.1, because there is no 5.0.2 to select)
* Ruby 3.0.2
* PostgreSQL 14
* 150.000 issues
* 500 projects
* 40 custom fields for issues
<pre><code class="ruby">
"((#{sql}) AND (#{tracker_condition}) AND (#{project_condition}))"
</code></pre> </pre>
to
<pre><code class="ruby">
"((#{sql}) AND (#{tracker_condition}) AND (#{project_condition}) AND (#{Issue.visible_condition(user)}))"
</code></pre> </pre>
we got massive performance problems on issue list.
Some information to the system environment:
* Redmine 5.0.2 (for this issue I selected 5.0.1, because there is no 5.0.2 to select)
* Ruby 3.0.2
* PostgreSQL 14
* 150.000 issues
* 500 projects
* 40 custom fields for issues