Re: High CPU Utilization

[Craig Dominaux]

Thanks Jay

So this is what I have done created 2 Indexes and limited the group_uid and attribute_name to 50 (I know for a fact that these values will never go past 20 characters but I set it to 50 to be safe.

CREATE INDEX datatree_attribute_id_nam_idx ON horde_datatree_attributes (datatree_id, attribute_name(50) );
CREATE INDEX datatree_group_id_idx ON horde_datatree (group_uid(50), datatree_id);

I was able to modify the code and remove GROUP BY and ORDER BY from the query because it is only suppose to return 1 row at all times.

I will update you on the performance once I get a load