Part of #63.
Problem
RulesEngine::storeScanDetail() (app/app/Services/RulesEngine/RulesEngine.php:595) issues one INSERT per API response. An EC2 region with 50 instances × 3 actions is ~200 individual round trips to MySQL.
Change
Buffer detail rows per task and bulk-insert them.
Priority: P2
Part of #63.
Problem
RulesEngine::storeScanDetail()(app/app/Services/RulesEngine/RulesEngine.php:595) issues oneINSERTper API response. An EC2 region with 50 instances × 3 actions is ~200 individual round trips to MySQL.Change
Buffer detail rows per task and bulk-insert them.
Priority: P2