[TC-372] Assigning ds's to user thru API takes too long

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.1.0
• Component/s: Traffic Ops, Traffic Ops API
• Labels: delivery_service tenant user
• Assignee: Jeremy Mitchell
• Reporter: Jeremy Mitchell
• Created: 08/Jun/17 17:28
• Updated: 30/Jun/17 15:26
• Resolved: 30/Jun/17 15:10

Description

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

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

and it loops thru each ds to perform a query to see if it exists and then does a query to do an insert into the deliveryservice_tmuser table. so if you're assigning 500 ds's to a user...you end up with 1000 queries...
need to optimize this endpoint.

Issue Links

• links to: GitHub Pull Request #657