Red Hat Bugzilla – Bug 1301951
[scale] - getstorage_domain_by_type_storagepoolid_and_status hit the engine start up
Last modified: 2017-10-26 04:45:11 EDT
Description of problem:
this has been called many time, while the engine rising.
the query hit the performance since his avg time to execute is ~20 sec.
- query optimization.
- reduce the # of calls (caching or something similar).
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. start the engine
long execution time, lots # of calls
fewer # of calls, optimized query with fast response time.
Bug tickets must have version flags set prior to targeting them to a release. Please ask maintainer to set the correct version flags and only then set the target milestone.
Moving from 4.0 alpha to 4.0 beta since 4.0 alpha has been already released and bug is not ON_QA.
oVirt 4.0 beta has been released, moving to RC milestone.
Please re-test in 4.2 with PG 9.5
(In reply to Yaniv Kaul from comment #7)
> Please re-test in 4.2 with PG 9.5
what exactly are we looking for ?
whats "lots # of calls"
what query should i compare and what is efficient improvement ?
(In reply to eberman from comment #8)
> (In reply to Yaniv Kaul from comment #7)
> > Please re-test in 4.2 with PG 9.5
> what exactly are we looking for ?
> whats "lots # of calls"
> what query should i compare and what is efficient improvement ?
I don't know - you guys opened the bug... We want to get base numbers in 4.2 (compared to the initial report in comment 1 )