{"data":{"id":"ACP2E-4496","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where the analytics cron job causes performance degradation during execution, resulting in improved overall system performance.","categories":["Performance","Cron"],"components":["magento/module-analytics"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-80/acp2e-4496","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-80/acp2e-4496.md","blobSha":"3430a4f00ab16802d667776c04992158db5fbf1a","description":"The analytics cron job causes performance degradation during execution and increases database load.","stepsToReproduce":"1. Enable MBI analytics. 1. Generate a large amount of entries in the sales_order_item table. 1. Run the analytics_collect_data cron and measure the time taken to complete.","introducedInQpt":"1.1.80","createdFor":["2.4.8-p3"],"documentedRange":"2.4.8 - 2.4.8-p5","scheduledFixRelease":"2.4.9"},"files":[{"package":"magento/magento2-base","constraint":">=2.4.8 <2.4.9","path":"patches/os/ACP2E-4497_2.4.8-p3.patch","blobSha":"e067794be19bd8c66ff7b3d733b12a1ddc245d9f","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACP2E-4497_2.4.8-p3.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-analytics/ReportXml/ReportProvider.php","change":"modified","package":"magento/module-analytics"}],"packages":["magento/module-analytics"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8"],"magento-commerce":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8"],"magento-commerce":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACP2E-4496 details"}