Skip to content

Improve DB performance in PolicyRuleScheduleNamespaceWorker

What does this MR do and why?

This is an attempt to improve DB performance for the Security::OrchestrationPolicyRuleScheduleNamespaceWorker by:

  • Removing N+1 queries
  • Only selecting necessary fields

How to set up and validate locally

There should be no change in behavior. Only performance improvements.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #407269 (closed)

Edited by Andy Schoenen

Merge request reports