Feature #23743: Add index to workflows.tracker_id - Redmine

Actions

Feature #23743

closed

Status:

Closed

Priority:

Normal

Assignee:

Category:

Performance

Target version:

Start date:

Due date:

% Done:

Estimated time:

Resolution:

Fixed

Description

Hi,
when I enter in trackers#index the redmine make this query for each tracker:

SELECT COUNT(*) FROM "workflows" WHERE "workflows"."tracker_id" = $1

But there is no index for "workflows"."tracker_id", and each query takes 88ms +-

After add index each query takes 0.3ms

Actions

Also available in: Atom PDF