Red Hat Bugzilla – Full Text Bug Listing
|Summary:||Investigate truncating the oob temp table instead of doing delete from|
|Product:||[Other] RHQ Project||Reporter:||Heiko W. Rupp <hrupp>|
|Component:||Core Server||Assignee:||Heiko W. Rupp <hrupp>|
|Status:||CLOSED WONTFIX||QA Contact:|
|Fixed In Version:||Doc Type:||Enhancement|
|Doc Text:||Story Points:||---|
|Last Closed:||2010-08-07 10:05:41 EDT||Type:||---|
|oVirt Team:||---||RHEL 7.3 requirements from Atomic Host:|
Description Heiko W. Rupp 2009-03-12 09:53:00 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).
Comment 1 Joseph Marques 2009-03-22 10:46:56 EDT
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 15:46:18 EST
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 10:44:47 EST
mass move off the qa triage list. These are tasks for dev.
Comment 4 Heiko W. Rupp 2010-08-07 10:05:41 EDT
There have no performance issues been seen or been reported. So no need to work on this.