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

 
 

Drupal is a registered trademark of Dries Buytaert.