Project

General

Profile

Actions
Copy link

Patch #37350

closed

Do not load attachments in query list with description and last_notes

Added by Alexander Meindl over 2 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Issues list
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:

Description

Currently if you enable description and last notes inline columns in issue list, textilizable loads not required attachments. Attachments are not displayed in this list => it is not required to load it.

This behaviour create lot of not required database queries like:

  Attachment Load (0.4ms)  SELECT `attachments`.* FROM `attachments` WHERE `attachments`.`container_id` = 62115 AND `attachments`.`container_type` = 'Issue' ORDER BY attachments.created_on ASC, attachments.id ASC /*application:RedmineApp,controller:issues,action:index*/
  ↳ app/helpers/application_helper.rb:940:in `+'
  Attachment Load (0.4ms)  SELECT `attachments`.* FROM `attachments` WHERE `attachments`.`container_id` = 62114 AND `attachments`.`container_type` = 'Issue' ORDER BY attachments.created_on ASC, attachments.id ASC /*application:RedmineApp,controller:issues,action:index*/
  ↳ app/helpers/application_helper.rb:940:in `+'
  Attachment Load (0.4ms)  SELECT `attachments`.* FROM `attachments` WHERE `attachments`.`container_id` = 62113 AND `attachments`.`container_type` = 'Issue' ORDER BY attachments.created_on ASC, attachm

The attachment patch solves this problem.

Files

textilizable_without_attachment.patch (951 Bytes) textilizable_without_attachment.patch Alexander Meindl, 2022-06-26 11:48
Actions
Copy link

Also available in: Atom PDF