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)