Bug 97665

Summary: inefficient queries when requesting article
Product: [Retired] Red Hat Enterprise CMS Reporter: Bryan Che <bche>
Component: otherAssignee: Archit Shah <archit.shah>
Status: CLOSED CURRENTRELEASE QA Contact: Jon Orris <jorris>
Severity: medium Docs Contact:
Priority: medium    
Version: nightly   
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2003-07-03 17:51:31 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:
Bug Depends On:    
Bug Blocks: 92111    

Description Bryan Che 2003-06-18 22:08:20 UTC
I published an article and requested it.  According to ds, there are a bunch of
queries that would ideally be rolled into one for performance reasons.  For
example, there are 7 queries that each select a different column from the same
table:

select ao.object_id as column0,
       ao.default_domain_class as column1
from content_types ct,
     acs_objects ao
where ao.object_id = ct.type_id and ? = ct.type_id


    BINDS: {1=111}

	 
15	1 ms	521234698	

select ao.object_id as column0,
       ao.display_name as column1
from content_types ct,
     acs_objects ao
where ao.object_id = ct.type_id and ? = ct.type_id


    BINDS: {1=111}

	 
16	1 ms	521234698	

select ao.object_id as column0,
       ct.object_type as column1
from content_types ct,
     acs_objects ao
where ao.object_id = ct.type_id and ? = ct.type_id


    BINDS: {1=111}

and so on.