[
https://issues.apache.org/jira/browse/TC-134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jeremy Mitchell closed TC-134.
------------------------------
> /server/:id/view UI route spawns a large amount of sequential queries.
> Consolidate these queries.
> -------------------------------------------------------------------------------------------------
>
> Key: TC-134
> URL: https://issues.apache.org/jira/browse/TC-134
> Project: Traffic Control
> Issue Type: Improvement
> Components: Traffic Ops
> Affects Versions: 2.0.0
> Reporter: Jeremy Mitchell
> Assignee: Jeremy Mitchell
> Priority: Minor
> Fix For: 2.0.0
>
>
> https://github.com/apache/incubator-trafficcontrol/blob/master/traffic_ops/app/lib/UI/Server.pm#L57
> ^^ this code cause a large amount of sequential queries that does not work
> well with a TO --> remote Postgres setup.
> There is no need to fetch the additional information needed (xml_id) in this
> manner. Use a dbix prefetch on the original query instead.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
