Enhancement #13380
Archive program cause high CPU
Status: | Closed - End of life cycle | Start date: | January 05, 2023 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Rayvandy Gabbytian | % Done: | 0% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Problem:
The archive program will copy the record to a new table and then delete the record from old table. This caused high processing in the Report server.
Solution:
Due to bank already have the backup of daily data, archive is not necessary. Confirmed by BI. Therefore, will enhance our program to only perform delete the record. The program will delete yesterday record by batches execution.
Action:
To direct delete record using db query
Last status:
Already provided the patch to PTAP and deployed to NFT
History
#1 Updated by Tan Lee Yong about 1 year ago
- Assignee changed from Ngoh Chee Ping to Rayvandy Gabbytian
Reassign to Gabby to follow up
#2 Updated by Rayvandy Gabbytian about 1 year ago
- Status changed from Pending Prod Deployment to Closed - End of life cycle
deployed to production 13/05/2023
#3 Updated by Rayvandy Gabbytian about 1 year ago
deployed to production 18/05/2023