Bulk operations for Vulnerability state changes.

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

Time-box: 2 days

Problem

Our vulnerabilityResolve (and other GraphQL state mutations) are slow – #391419 (closed). We need to investigate possible options to make them faster.

Proposed solutions

• Offload big batches to Sidekiq

Expected Outcomes

• Determine needed scope of frontend work necessary to facilitate async bulk state changes
• Consider other possible solutions to optimise vulnerability state changes. (Partitioning or other possible table optimisations?)
• Determine scope of backend work to facilitate async bulk state changes (api, response codes to FE
• Consider possible dangers of the implementation and mitigations (deadlock, race conditions, data inconsistencies from dismissing a vulnerability being bulk dismissed...)