new index for workflow_states
dalin - October 19, 2009 - 03:32
| Project: | Workflow |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
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);
