https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292016-12-13T20:09:52ZRedmineRedmine - Feature #24553: missing index on table custom_valueshttps://www.redmine.org/issues/24553?journal_id=750232016-12-13T20:09:52ZJean-Philippe Langjp_lang@yahoo.fr
<ul><li><strong>Target version</strong> set to <i>3.4.0</i></li></ul> Redmine - Feature #24553: missing index on table custom_valueshttps://www.redmine.org/issues/24553?journal_id=752012016-12-21T10:40:37ZJean-Philippe Langjp_lang@yahoo.fr
<ul></ul><p>When accessing the custom values of an object, we have to filter on customized_id and customized_type (eg. = 'Issue'). Would it make sense to add the index on [customized_type, customized_id] instead of customized_id alone?</p> Redmine - Feature #24553: missing index on table custom_valueshttps://www.redmine.org/issues/24553?journal_id=756692017-01-06T01:26:19ZToshi MARUYAMA
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/18696">Defect #18696</a>: MySQL Queries are Slow</i> added</li></ul> Redmine - Feature #24553: missing index on table custom_valueshttps://www.redmine.org/issues/24553?journal_id=759372017-01-14T13:58:58ZJean-Philippe Langjp_lang@yahoo.fr
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Target version</strong> deleted (<del><i>3.4.0</i></del>)</li></ul><p>Actually, there's already an index on [customized_type, customized_id]. You should always have a condition on both in your queries. I'm closing it, please reopen if you can give some feedback.</p> Redmine - Feature #24553: missing index on table custom_valueshttps://www.redmine.org/issues/24553?journal_id=773222017-03-16T12:19:17ZLars Vandam
<ul></ul><p>Hi,<br />sorry for the late feedback. <br />Our report queries are not using customized_type (its always 'Issue').<br />Currently our custom_values table has 220K rows and without the index on customized_id it would be too slow.<br />Regards,<br />Lars</p>