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);
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | workflow-weight-index.patch | 580 bytes | dawehner |
Comments
Comment #1
dawehnerHere is a patch
Comment #2
Bastlynn commentedSince 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.