Project

General

Profile

Actions
Copy link

개선(improvement) #1098

closed

[Dashboard] Apply caching for MoM, QoQ chart

Added by Joseph Vo 7 months ago. Updated 4 months ago.

Status:
완료성공(Resolve)
Priority:
보통(Normal)
Assignee:
Tom Dong
Start date:
10/06/2025
Due date:
10/06/2025
% Done:

100%

Estimated time:
Part:
Build env.:
Prod

Description

Request :
Apply caching for MoM, QoQ chart, improve the loading performance

Files

Download all files
image.png (110 KB) image.png Joseph Vo, 08/06/2025 08:14 AM
Ohmy Admin and 2 more pages - Work 2 - Microsoft​ Edge 2025-10-08 08-29-54.mp4 (11 MB) Ohmy Admin and 2 more pages - Work 2 - Microsoft​ Edge 2025-10-08 08-29-54.mp4 data display speed Tracy Truong, 10/08/2025 01:31 AM
Ohmy Admin and 2 more pages - Work 2 - Microsoft​ Edge 2025-10-08 08-57-34.mp4 (19.9 MB) Ohmy Admin and 2 more pages - Work 2 - Microsoft​ Edge 2025-10-08 08-57-34.mp4 Show information Tracy Truong, 10/08/2025 01:58 AM
Ohmy Admin and 7 more pages - Work 2 - Microsoft​ Edge 2025-10-08 13-47-52.mp4 (18.4 MB) Ohmy Admin and 7 more pages - Work 2 - Microsoft​ Edge 2025-10-08 13-47-52.mp4 Tracy Truong, 10/08/2025 06:48 AM
Ohmy Admin and 4 more pages - Work 2 - Microsoft​ Edge 2025-10-10 15-22-20.mp4 (7.29 MB) Ohmy Admin and 4 more pages - Work 2 - Microsoft​ Edge 2025-10-10 15-22-20.mp4 Tracy Truong, 10/10/2025 08:23 AM
Ohmy Admin and 9 more pages - Work 2 - Microsoft​ Edge 2025-10-23 14-44-01.mp4 (16.9 MB) Ohmy Admin and 9 more pages - Work 2 - Microsoft​ Edge 2025-10-23 14-44-01.mp4 Tracy Truong, 10/23/2025 07:50 AM
1098.mp4 (46.5 MB) 1098.mp4 Tracy Tran, 11/05/2025 08:50 AM

Related issues

Related to Ellis improvement - 개선(improvement) #1760: [Admin Site] Improve Admin Site performance신규(New)Dan Hoang09/30/202512/16/2025

Actions
Related to Ellis improvement - 개선(improvement) #2043: [Dashboard] Apply caching Reservations chart완료성공(Resolve)Tom Dong10/23/202510/23/2025

Actions
Actions
Copy link
 #1

Updated by Joseph Vo 7 months ago

  • Assignee set to Tom Dong
Actions
Copy link
 #2

Updated by Joseph Vo 5 months ago

Actions
Copy link
 #3

Updated by Tom Dong 5 months ago

  • Due date set to 10/06/2025
  • Status changed from 신규(New) to 진행(Doing)
  • Start date set to 10/06/2025
Actions
Copy link
 #4

Updated by Tom Dong 5 months ago

  • % Done changed from 0 to 70
Actions
Copy link
 #5

Updated by Tom Dong 5 months ago

  • Status changed from 진행(Doing) to QA test
  • Assignee changed from Tom Dong to Tracy Truong
  • % Done changed from 70 to 100
Actions
Copy link
 #6

Updated by Tom Dong 5 months ago

  • Build env. set to Dev
Actions
Copy link
 #7

Updated by Tracy Truong 5 months ago

Prod: take 13s to load data
DEV: Show information as soon as tab is opened => ok
Change CUR > data display speed ok

About data: will check on STAG

Actions
Copy link
 #8

Updated by Tom Dong 5 months ago

Auto cache

Time: 30m
Default: Contries ("JPY", "KRW", "VND"), Date Type: Check-out, Year: now ~ now + 1

Client cache

Cache: search filter by user
Time: 30m

Actions
Copy link
 #9

Updated by Tom Dong 5 months ago

  • Status changed from 완료(Done) to QA test
  • Assignee changed from Tom Dong to Tracy Truong
  • Build env. changed from Dev to Staging
Actions
Copy link
 #10

Updated by Tracy Truong 5 months ago

Take many time to loading (as attached video)

Actions
Copy link
 #11

Updated by Tom Dong 5 months ago

  • Status changed from 완료실패(Failed) to QA test
  • Assignee changed from Tom Dong to Tracy Truong

Trên STG hiện tại không có auto cache data trước-> nên khi search lần đầu tiên sẽ chậm -> lần thứ 2 cùng điều kiện đó sẽ nhanh
Dữ liệu cache được 30min, nên người dùng khác search cùng điều kiện sẽ nhanh theo.
Nếu quá 30min cache sẽ mất, lúc này hệ thống sẽ lấy dữ liệu mới nên thời gian sẽ chậm

Nút refresh: Lấy giá trị mới nhất lưu vào cache
LastUpdate: Thời gian cache gần nhất

Actions
Copy link
 #12

Updated by Tracy Truong 5 months ago

Checked on STAG,
Open dashboard tab > MoM/ QoQ/ Yearly Performance Report chart shows data instantly => ok

Actions
Copy link
 #13

Updated by ziniy Kang 5 months ago

  • Status changed from 완료(Done) to 확인(Confirmed)
Actions
Copy link
 #14

Updated by Tom Dong 5 months ago

  • Status changed from 확인(Confirmed) to QA test
  • Assignee changed from Tom Dong to Tracy Truong
  • Build env. changed from Staging to Prod
Actions
Copy link
 #15

Updated by Tom Dong 5 months ago

Actions
Copy link
 #16

Updated by Tracy Truong 5 months ago

Failed. Please recheck cache

Actions
Copy link
 #17

Updated by Tom Dong 4 months ago

  • Status changed from 완료실패(Failed) to QA test
  • Assignee changed from Tom Dong to Tracy Truong
Actions
Copy link
 #18

Updated by Tracy Tran 4 months ago

  • File 1098.mp4 1098.mp4 added
  • Status changed from QA test to 완료성공(Resolve)
  • Assignee changed from Tracy Truong to Tom Dong

Checked on PROD OK

Actions
Copy link

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 50 MB)