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);

CommentFileSizeAuthor
#1 workflow-weight-index.patch580 bytesdawehner

Comments

dawehner’s picture

Status: Active » Needs review
StatusFileSize
new580 bytes

Here is a patch

Bastlynn’s picture

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.