[jira] [Closed] (TC-134) /server/:id/view UI route spawns a large amount of sequential queries. Consolidate these queries.

["Jeremy Mitchell (JIRA)" <ji...@apache.org>]

     [ 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)