Project

General

Profile

Actions
Copy link

Bug #401

open
LN KB

Slow performance on ERP portal

Bug #401: Slow performance on ERP portal

Added by Linh Ngô 16 days ago.

Status:
Feedback
Priority:
Urgent
Assignee:
Khánh Bùi
Start date:
06/19/2026
Due date:
06/26/2026 (15 days late)
% Done:

80%

Estimated time:
6:00 h

Description

Multiple Sales users report the ERP dashboard takes 30+ seconds to load since this morning.

LN Updated by Linh Ngô 22 days ago · Edited Actions
Copy link
 #1

Multiple users from Sales report the ERP portal takes 30+ seconds to load the dashboard since this morning.

KB Updated by Khánh Bùi 22 days ago · Edited Actions
Copy link
 #2

Confirmed. CPU on app server app-02 is steady at 95%. Checking the slow query log.

KB Updated by Khánh Bùi 21 days ago · Edited Actions
Copy link
 #3

Found a missing index on orders.customer_id — full table scan on every dashboard load.

EH Updated by Em Hoàng 21 days ago · Edited Actions
Copy link
 #4

Same slowness reproduced from the Hanoi office, so it is server-side, not network.

KB Updated by Khánh Bùi 20 days ago · Edited Actions
Copy link
 #5

Added the index in staging, dashboard load dropped to 2.1s. Preparing production migration.

LN Updated by Linh Ngô 20 days ago · Edited Actions
Copy link
 #6

Please schedule the production change outside business hours and notify Sales.

KB Updated by Khánh Bùi 19 days ago · Edited Actions
Copy link
 #7

Migration applied at 21:00. Monitoring shows load times back to ~1.8s.

EH Updated by Em Hoàng 18 days ago · Edited Actions
Copy link
 #8

Spot-checked 5 user accounts this morning — all confirm it is fast again.

LN Updated by Linh Ngô 18 days ago · Edited Actions
Copy link
 #9

Great. Keep the ticket open one more day to confirm stability before closing.

Actions
Copy link

Also available in: PDF Atom