Posted by dalin on October 19, 2009 at 3:32am
| 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
Here is a patch
#2
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.