Re: High CPU Utilization
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
Subject
Views
Written By
Posted
4733
September 21, 2005 03:23PM
1969
September 21, 2005 05:28PM
2072
September 22, 2005 09:48AM
1742
September 22, 2005 01:13PM
1848
September 22, 2005 01:50PM
3084
September 23, 2005 07:37AM
Re: High CPU Utilization
1718
September 23, 2005 08:52AM
1714
September 23, 2005 09:14AM
1780
September 23, 2005 02:45PM
1813
September 23, 2005 04:00PM
1768
September 23, 2005 11:27AM
1903
September 23, 2005 12:03PM
1740
September 23, 2005 12:43PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.