Jeremy Mitchell created TC-231:
----------------------------------
Summary: GET /api/deliveryservices is very slow when resultset
gets large
Key: TC-231
URL: https://issues.apache.org/jira/browse/TC-231
Project: Traffic Control
Issue Type: Improvement
Components: Traffic Ops API
Affects Versions: 2.0.0, 2.1.0
Reporter: Jeremy Mitchell
Assignee: Jeremy Mitchell
With the change from mysql to postgres and when postgres is hosted in a remote
environment (seperate from TO), /api/version/deliveryservices is very slow as
the number of delivery services grows. This is because the code loops thru the
result set and builds "example urls" for each deliveryservice. This operation
is expensive.
Rather than breaking the API and leaving out exampleURLs by default from the
response, I suggest we allow the API consumer to pass thru a query parameter
such as:
?exclude=exampleURLs
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
