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

["Ryan Durfey (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TC-371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ryan Durfey updated TC-371:
---------------------------
    Labels: assignment delivery_service server  (was: )

> 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
>              Labels: assignment, delivery_service, server
>
> 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.4.14#64029)