https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292016-04-20T22:05:05ZRedmineRedmine - Feature #22594: Optimize retrieve_previous_and_next_issue_idshttps://www.redmine.org/issues/22594?journal_id=704722016-04-20T22:05:05ZJérôme BATAILLE
<ul></ul><p>What is slow is the issue display.</p>
<p>The scope parameters :<br /><pre>
WHERE 0 ((projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND ((projects.id IN (11,141,144,433,742,919,1214,1226,1227,1228,1229,1233,1234,1235,1238,1240,1241,1243,1246,1247,1248,1249,1250,1251,1252,1255,1256,1257,1259,1260,1261,1262,1263,1265,1266,1267) AND ((issues.is_private = 0 OR issues.author_id = 1281 OR issues.assigned_to_id IN (1281,1298,3895))))) )
1 (issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=0)) AND (issues.tracker_id IN ('2','3')) AND projects.id IN (1226,1262,1263,1252,1261,1235,1227,1249,1228,1243,1260,1238,1244,1258)
INCLUDES [:project, :assigned_to, :priority, :category, :fixed_version]
JOINS [:status, :project]
ORDER ["issues.root_id", "issues.lft ASC"]
</pre></p> Redmine - Feature #22594: Optimize retrieve_previous_and_next_issue_idshttps://www.redmine.org/issues/22594?journal_id=704732016-04-20T22:08:08ZJérôme BATAILLE
<ul></ul><p>I suppose that what is slow is the Issues and related models loading, but we don't need all the members because here we only need the issues ids.<br />I tried to replace the includes by joins with no success.</p>
<p>Has someone an idea ? preload ? select ?</p> Redmine - Feature #22594: Optimize retrieve_previous_and_next_issue_idshttps://www.redmine.org/issues/22594?journal_id=710122016-05-19T12:02:36ZToshi MARUYAMA
<ul><li><strong>Category</strong> set to <i>Code cleanup/refactoring</i></li></ul>