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

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

Jeremy Mitchell created TC-134:
----------------------------------

             Summary: /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)