Redmine

Hi,

we were facing a performance issue while querying redmine database to generate some reports over all tickets. We are using lots of custom values and want to have all in the output. Problem was that the MySQL Query was slow and lasts over 10 minutes.

I checked database structure and found that there is an index missing on column customized_id in table custom_values.

After adding the index the query fast (~ 1 sec) and all is fine.

Maybe you can check whether to add the index in the future releases.

We are running:
Redmine version 3.1.1.stable
Ruby version 2.0.0-p384 (2014-01-12) [x86_64-linux-gnu]
Rails version 4.2.4
Server: Ubuntu 14.04.5 LTS

query:
CREATE INDEX custom_values_index1 ON custom_values (customized_id);

I am not sure but maybe this is related to Defect #18696 since this query is using same column.

Regards,
Lars Vandam