Project

General

Profile

Feature #19324

add completed jobs index

Added by Marc Mengel over 2 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
High
Assignee:
Target version:
Start date:
03/07/2018
Due date:
% Done:

100%

Estimated time:
Scope:
Internal
Experiment:
-
Stakeholders:
Duration:

Description

Testing in development would indicate:

create index idx_jobs_completed on jobs (status,job_id) where status = 'Completed';

speeds up some of our job status queries for workflow code significantly. It should remain a small index due to the where clause...

It would be good to add this to the official sql schema and roll into the upcoming v3_0_0 release.

History

#1 Updated by Marc Mengel over 2 years ago

  • Target version changed from v3_0_0 to v3_1_0

Per brief discussion this morning, deferring to v3_1_0.

#2 Updated by Anna Mazzacane over 2 years ago

  • Priority changed from Normal to High

#3 Updated by Anna Mazzacane over 2 years ago

  • Assignee changed from Stephen White to Vladimir Podstavkov

#4 Updated by Stephen White over 2 years ago

  • Status changed from New to Resolved
  • Assignee changed from Vladimir Podstavkov to Stephen White
  • % Done changed from 0 to 100

Added for all statuses not just completed.

#5 Updated by Stephen White about 2 years ago

  • Status changed from Resolved to Closed


Also available in: Atom PDF