[jira] [Created] (TC-371) Assigning servers to ds thru API takes too long

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

Jeremy Mitchell created TC-371:
----------------------------------

             Summary: Assigning servers to ds thru API takes too long
                 Key: TC-371
                 URL: https://issues.apache.org/jira/browse/TC-371
             Project: Traffic Control
          Issue Type: Improvement
          Components: Traffic Ops API
            Reporter: Jeremy Mitchell
            Assignee: Jeremy Mitchell
            Priority: Minor


POST /api/$version/deliveryserviceserver takes the following payload:

{  dsId: 42, servers: [1,2,3,4,5,6,7,8,9...] }

and it loops thru each server to perform a query to see if it exists and then does a query to do an insert into the deliveryservice_server table. so if you're assigning 500 servers to a ds...you end up with 1000 queries... 

need to optimize this endpoint.





--
This message was sent by Atlassian JIRA
(v6.3.15#6346)