Feature #23743

Add index to workflows.tracker_id

Added by Victor Campos about 1 year ago. Updated 12 months ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:Jean-Philippe Lang% Done:

0%

Category:Performance
Target version:3.4.0
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

Associated revisions

Revision 15859
Added by Jean-Philippe Lang 12 months ago

Add index to workflows.tracker_id (#23743).

History

#1 Updated by Go MAEDA about 1 year ago

  • Target version set to Candidate for next minor release

#3 Updated by Toshi MARUYAMA about 1 year ago

  • Target version changed from Candidate for next minor release to 3.4.0

#4 Updated by Jean-Philippe Lang 12 months ago

  • Status changed from New to Closed
  • Assignee set to Jean-Philippe Lang
  • Resolution set to Fixed

Index added in r15859.

Also available in: Atom PDF