Support #14112
[SCP ID :##7101##] : Perlambatan Response Time API Portal
Status: | Pending Customer Feedback | Start date: | August 09, 2024 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Bramantyo Pujo Wiyono | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
Ditemukan perlambatan response API Portal sehingga menjebabkan timeout (> 180 Seconds),
Sebagai informasi average response time untuk setiap pagi API (memberstatemen/ CT DetaiL) adalah sekitar 50 Seconds, cmiiw.
Adapunn data yang response time melebihi 180 Seconds, adalah sebagai berikut:
No
Tanggal
Jam Request
uri_path
API Path
1
12 Mei 2024
19:12:23.506
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
2
13 Mei 2024
11:01:37.596
/bi/bi-fast/v1.0/bi-fast/informational/member/statement
Member Statement
3
15 Mei 2024
15:23:27.003
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
4
16:34:06.815
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
5
10 Juni 2024
13:01:40.169
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
6
13 Juni 2024
21:01:34.709
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
7
1 Juli 2024
14:01:31.283
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
1
16 Mei 2024
22:01:21.272
/bi/bi-fast/v1.0/bi-fast/informational/member/statement
Member Statement
2
26 Mei 2024
18:36:29.469
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
3
11 Juni 2024
18:01:42.394
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
4
17 Juli 2024
18:01:38.488
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
5
31 Juli 2024
18:55:23.926
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
6
6 Agustus 2024
11:00:16.740
/bi/bi-fast/v1.0/bi-fast/informational/member/statement
Member Statement
7
17:06:06.760
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
8
19:01:37.944
/bi/bi-fast/v1.0/bi-fast/informational/member/statement
Member Statement
9
19:01:38.529
/bi/bi-fast/v1.0/bi-fast/informational/credit-transfer/detail
CT Detail
Mohon bantuan analisanya.
History
#1 Updated by Bramantyo Pujo Wiyono about 1 month ago
- Status changed from New - Begin Life Cycle to Investigation
Need to investigate the request and check the volume data transaction, to analyze whether the query to db slow because of the volume data or because of the db server resource utilization
#2 Updated by Bramantyo Pujo Wiyono 23 days ago
- Status changed from Investigation to Development / Work In Progress
- % Done changed from 0 to 50
Enhance the performace by simplify the db query and caching one time get from db for serviceType list object that previously will get serviceType object directly from db to identify service type name of each transaction.
by doing this enhancement there are quite good improvement on respose time, test on NFT data using current prod ver take 60-120sec and enhance ver take around 5-10sec.
#3 Updated by Bramantyo Pujo Wiyono 23 days ago
- Status changed from Development / Work In Progress to Internal Testing
#4 Updated by Bramantyo Pujo Wiyono 17 days ago
After testing we found out that the enhance version on local machine and deployed on NFT had different performance.
On run the service on the local machine the enahnce version had much improvement, mean while run the service deployed on nft only had slightly different performance between the enahnced version and current productionn version.
so, still need more time to find another way to enhance the performance.
#5 Updated by Bramantyo Pujo Wiyono 17 days ago
- Status changed from Internal Testing to Development / Work In Progress
i tried to enhance by converting the db query using native sql and it improve the performance time.
Demo testing deployed on NFT
1 day of data aproximate 23million row
1 hour of data 1.2million row
-------------- 1Day Data | 1Hours Data
-MemberStatement
Current prod: 27sec 48ms | 28sec 23ms
Enhanced : 13sec 92ms | 12sec 23ms
-CreditTransferDetail
Current prod: 26sec 2ms | 28sec 18ms
Enhanced : 5sec 48ms | 2sec 3ms
Based on those 2 service enhancement result, so i will continue to update all the related service to convert using native sql
- MemberStatement
- CreditTransferDetail
- CreditTransferRejected
- CreditTransferSent
- CreditTransferReceived
- BulkCreditReceived
- BulkCreditRejected
- BulkCreditSend
- BulkCreditTransferDetail
- DirectDebitReceived
- DirectDebitRejected
- DirectDebitSend
- DirectDebitDetails
- RequestForPayReceived
- RequestForPayRejected
- RequestForPaySend
- RequestForPayDetails
#6 Updated by Bramantyo Pujo Wiyono 16 days ago
- Status changed from Development / Work In Progress to Internal Testing
Done development for enhancment for all the service:
- MemberStatement
- CreditTransferDetail
- CreditTransferRejected
- CreditTransferSent
- CreditTransferReceived
- BulkCreditReceived
- BulkCreditRejected
- BulkCreditSend
- BulkCreditTransferDetail
- DirectDebitReceived
- DirectDebitRejected
- DirectDebitSend
- DirectDebitDetails
- RequestForPayReceived
- RequestForPayRejected
- RequestForPaySend
- RequestForPayDetails
#7 Updated by Bramantyo Pujo Wiyono 15 days ago
- Status changed from Internal Testing to Finished Development
#8 Updated by Bramantyo Pujo Wiyono 15 days ago
- Status changed from Finished Development to Pending Customer Feedback
- % Done changed from 50 to 100
The patch release to ptap on 04SEP2024:
https://penrilsb-my.sharepoint.com/:f:/g/personal/haida_md_penril_net/EjFN9rzYM6NOj53y1DTSXgEBnOMup8ZQ2QJH4E877cH8Ig?e=3xYfh1