Bug 535033 (RHQ-1771)

Summary: Investigate truncating the oob temp table instead of doing delete from
Product: [Other] RHQ Project Reporter: Heiko W. Rupp <hrupp>
Component: Core ServerAssignee: Heiko W. Rupp <hrupp>
Status: CLOSED WONTFIX QA Contact:
Severity: medium Docs Contact:
Priority: low    
Version: 1.2Keywords: FutureFeature, Task
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: All   
URL: http://jira.rhq-project.org/browse/RHQ-1771
Whiteboard:
Fixed In Version: Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-08-07 14:05:41 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Heiko W. Rupp 2009-03-12 13:53:00 UTC
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).

Comment 1 Joseph Marques 2009-03-22 14:46:56 UTC
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.

Comment 2 Red Hat Bugzilla 2009-11-10 20:46:18 UTC
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-1771
This bug is related to RHQ-1738


Comment 3 wes hayutin 2010-02-16 15:44:47 UTC
mass move off the qa triage list.  These are tasks for dev.

Comment 4 Heiko W. Rupp 2010-08-07 14:05:41 UTC
There have no performance issues been seen or been reported. So no need to work on this.