Optimize "pull_mirrors_batch" query
- Suggested in !92422 (comment 1026848136)
- Follow-up for #216783 (closed)
Problem
We currently use a complex and slow query to select pull mirrors we need to update
Merge request !92422 (merged) added deactivation feature for mirrors that we don't update due to license check.
Proposal
It should be possible to remove check_mirror_plans_in_query?
branch from the query and improve the performance.
Potential problems
The query without check_mirror_plans_in_query?
is less restrictive and can select pull mirrors we haven't updated before. We need to evaluate the impact on customers.