[GitHub] [trafficcontrol] rawlinp opened a new issue #5674: Add query parameter option to Traffic Ops GET /jobs API to return only jobs created during maxRevalDurationDays window

[GitBox <gi...@apache.org>]

rawlinp opened a new issue #5674:
URL: https://github.com/apache/trafficcontrol/issues/5674


   ## I'm submitting a ...
   -  improvement request (usability, performance, tech debt, etc.)
   
   ## Traffic Control components affected ...
   -  Traffic Ops
   -  Traffic Ops ORT
   
   ## Current behavior:
   The Traffic Ops `GET /api/x/jobs` API currently returns all invalidation jobs ever created. For applications like ORT that really only need to get _unexpired_ invalidation jobs, this is very inefficient.
   
   ## New behavior:
   Provide a query parameter option to return only invalidation jobs created within the `maxRevalDurationDays` window. Update ORT to use the new query parameter option. For performance reasons, we might want to add a DB index on the `start_time` column w/ `DESC NULLS LAST`, similar to the `last_updated` index.
   
   ## Minimal reproduction of the problem with instructions:
   Request the TO `GET /api/x/jobs` route, observe that every job ever created is returned.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [trafficcontrol] ocket8888 closed issue #5674: Add query parameter option to Traffic Ops GET /jobs API to return only jobs created during maxRevalDurationDays window

[GitBox <gi...@apache.org>]

ocket8888 closed issue #5674:
URL: https://github.com/apache/trafficcontrol/issues/5674


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@trafficcontrol.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org