Bug 97665
| Summary: | inefficient queries when requesting article | ||
|---|---|---|---|
| Product: | [Retired] Red Hat Enterprise CMS | Reporter: | Bryan Che <bche> |
| Component: | other | Assignee: | 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 | ||
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.