Project:Workflow
Version:6.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (won't fix)

Issue Summary

Don't know much about workflow, but there were several workflow created queries involving workflow_states that came up in my slow query log as a result of these queries not being able to utilize any of the existing indexes on that table. Adding the following index made these go away:

ALTER TABLE {workflow_states} ADD INDEX weight(wid, sid, weight);

Comments

#1

Status:active» needs review

Here is a patch

AttachmentSize
workflow-weight-index.patch 580 bytes

#2

Status:needs review» closed (won't fix)

Since this request is over a year old, I'm going to assume a solution was found or you've moved on. If not, please get updated to the latest versions of all modules and make a patch for it against Drupal 7 and I'll be glad to take a look at it.