[TC-371] Assigning servers to ds thru API takes too long

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.1.0
• Component/s: Traffic Ops API
• Labels: assignment delivery_service server
• Assignee: Jeremy Mitchell
• Reporter: Jeremy Mitchell
• Created: 08/Jun/17 16:20
• Updated: 30/Jun/17 15:26
• Resolved: 30/Jun/17 15:05

Description

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.

Issue Links

• links to: GitHub Pull Request #656