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: [email protected]
