Red Hat Bugzilla – Bug 535033
Investigate truncating the oob temp table instead of doing delete from
Last modified: 2010-08-07 10:05:41 EDT
In RHQ-1738 one of the issues was that Oracle does not like the "truncate table" statement, which has been changed to "delete from".
We need to investigate if this causes issues performance wise (none seen so far).
remember, even though the baseline calculation job is running every hour now, it is /only/ recalculating the baselines that are "stale". so, whereas with the previous algorithm all baselines were deleted and recalculated at the same time across all measurement schedules, it's now likely that only a fraction of the baselines will recalculate at any given point in time. likewise, the oob algorithm could be adjusted to only delete/recalc oobs that have had their baselines recalculated during the same purge job.
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-1771
This bug is related to RHQ-1738
mass move off the qa triage list. These are tasks for dev.
There have no performance issues been seen or been reported. So no need to work on this.