{"data":{"id":"ACP2E-4748","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where reward points expiration can process slowly on stores with a large reward points history, causing delays in expiring reward points.","categories":["Customer","Performance"],"components":["magento/module-reward"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-82/acp2e-4748","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-82/acp2e-4748.md","blobSha":"6f519e764fc1e548f9b1ba2a96629d7823a370a6","description":"Reward points expiration runs slowly on stores with a large reward points history, causing delays in expiring reward points.","stepsToReproduce":"1. Go to Admin > Stores > Settings > Configuration > Customers > Reward Points. 1. Set Enable Reward Points Functionality to Yes, set Reward Points Expire in (days) to a positive value, and then click Save Config. 1. Confirm that the magento_reward and magento_reward_history tables contain a very large number of records. 1. Wait for the magento_reward_expire_points cron job to execute. 1. Measure the execution time of the query executed by Magento\\Reward\\Model\\ResourceModel\\Reward\\History::expirePoints().","introducedInQpt":"1.1.82","createdFor":["2.4.8-p1"],"documentedRange":"2.4.7 - 2.4.8-p5","scheduledFixRelease":"2.4.9"},"files":[{"package":"magento/magento2-ee-base","constraint":">=2.4.7 <2.4.9","path":"patches/commerce/ACP2E-4749_2.4.8-p1.patch","blobSha":"bea9b12558a3417264e8e50b62ca150001e68d96","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACP2E-4749_2.4.8-p1.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-reward/Cron/ScheduledPointsExpiration.php","change":"modified","package":"magento/module-reward"},{"path":"vendor/magento/module-reward/Model/ResourceModel/Reward/History.php","change":"modified","package":"magento/module-reward"},{"path":"vendor/magento/module-reward/etc/db_schema.xml","change":"modified","package":"magento/module-reward"},{"path":"vendor/magento/module-reward/etc/db_schema_whitelist.json","change":"modified","package":"magento/module-reward"},{"path":"vendor/magento/module-reward/etc/di.xml","change":"modified","package":"magento/module-reward"}],"packages":["magento/module-reward"],"hasTests":false,"applicableVersions":{"magento-community":[],"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","2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":[],"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","2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACP2E-4748 details"}