Minor DB hygiene from the pre-alpha11 audit. The orchestra_workflow_version entity has no storage schema, so its workflow column is unindexed. It is queried by WorkflowVersionManager on publish, garbage collection, migration and admin paths (filtering versions by their workflow), which are cold paths, so this is low priority.

Still worth adding a (workflow) index (or a (workflow, revision) composite) while the module is pre-1.0 and schema changes are applied by hand, since it is cheaper to add now than after 1.0.0 when it would need an update hook. Add an orchestra_workflow_version storage schema declaring the index, mirroring the other engine entities' storage schemas.

Issue fork orchestra-3610756

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

About issue forks

Comments

mably created an issue. See original summary.

mably opened merge request !329

mably’s picture

mably commented
Status: Active » Needs review
mably’s picture

mably commented
Status: Needs review » Fixed

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.

  • mably committed 3c512259 on 1.x 
    task: #3610756 Index orchestra_workflow_version.workflow

By: mably

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.