[#HHQ-879] Browse Resources spending lot of time coming up resource counts

Hyperic HQ

Browse Resources spending lot of time coming up resource counts

Created: 04/May/07 11:49 AM Updated: 31/Jan/08 12:46 PM

Component/s:

Auth/Authz

Affects Version/s:

3.0.4

Fix Version/s:

3.1.0, 3.0.5

Last comment:	80 weeks, 6 days ago
Resolution Date:	04/May/07 02:48 PM

Description

« Hide

The performance on Browse Resources is hampered by the SQL which actually also counts by type. This is so that it can share the API with the Summary Counts portlet. This is unnecessary burden and the API should be made to support both without having the cost for Browse Resources.

All

Comments

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Charles Lee - 04/May/07 02:48 PM

Created new queries to lookup total count directly without grouping by type for Browse Resources. The performance increased from 1.5-7 sec to consistently under 2 seconds.