Follow Up #13312
Support #13197: [SCP ID :##6413##] : Performance issue when access transaction history - BIF-103803
DB Table Partition
Status: | Closed - End of life cycle | Start date: | November 10, 2022 | |
---|---|---|---|---|
Priority: | High | Due date: | ||
Assignee: | Rayvandy Gabbytian | % Done: | 0% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
PTAP and BI DBA are working together to implement the table partition which have been proven has huge improvement on the enquiry performance. We also developed a batch program to delete the partitions that out of the retention period.
History
#1 Updated by Stephanie Sufrapto almost 2 years ago
22 November 2022¶
Check point¶
Partition table progress:
-RPP_TRNX_LOG_FEE:
Partition implemented
Data 30 days back until 20 oct
-RPP_TRNX_LOG_DATA:
Partition not implemented yet
Data insert 90 days in progress
06 Nov - 21 Nov
Fee report performance after update to partition:
a. fee summary 4 min 12 sec
b. fee detail 47 min
c. RTGS MT 57 sec
#2 Updated by Tan Lee Yong over 1 year ago
RPP_TRNX_LOG_DATA:
Due partition deployment failed and this patch is being roll back on December 1st.
RPP_TRNX_LOG_FEE:
No rollback
#3 Updated by Tan Lee Yong about 1 year ago
- Assignee changed from Stephanie Sufrapto to Rayvandy Gabbytian
This issue resolved and implemented successfully on July
#4 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