Uploaded image for project: 'Traffic Control'
  1. Traffic Control
  2. TC-134

/server/:id/view UI route spawns a large amount of sequential queries. Consolidate these queries.

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.0.0
    • 2.0.0
    • Traffic Ops
    • None

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              mitchell852@apache.org Jeremy Mitchell
              mitchell852@apache.org Jeremy Mitchell
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Slack

                  Issue deployment