결함(Bug) #1514
closed[issue] Slow Traveler Name Search in Admin
100%
Description
I’d like to report a performance issue regarding the Traveler name search.
Path: Admin > Bookings > Hotel Bookings > (Search) Traveler name
Problem : The search speed is extremely slow — it takes so long that it feels almost like an infinite loading error.
Request : 1) Could you please explain the root cause?
2) we kindly request performance improvements, as this feature is frequently used in practice (e.g., for CS support).
Thank you for your support.
Files
Related issues
Updated by Tom Dong 6 months ago
Add column BK_BOOKING_TRAVELER_MASTER
ALTER TABLE BK_BOOKING_TRAVELER_MASTER ADD COLUMN TRAVELER_NAME_REVERSE VARCHAR(100);
CREATE INDEX XIF_BK_BOOKING_TRAVELER_MASTER_06 ON BK_BOOKING_TRAVELER_MASTER(TRAVELER_NAME_REVERSE);
UPDATE BK_BOOKING_TRAVELER_MASTER SET TRAVELER_NAME_REVERSE = REVERSE(TRAVELER_NAME);
Updated by Tom Dong 6 months ago
Dear Zia Han ,
---
The search slowness occurs because when searching by `travelerName`, the booking date condition was omitted.
This caused the query to scan more than 4M+ rows, leading to poor performance.
Proposed Solutions
- Option 1: Add a traveler suggestion control (~85% performance improvement)
- Introduce a dedicated search suggestion for traveler names.
- Users can search traveler names first, which makes subsequent searches more accurate and efficient.
- Example:
- Search traveler `"AKIHIRO"` in the new control
- Expected matches:
- `AKIHIRO`
- `AKIHIRO123`
- `AKIHIRO 123`
- Option 2: Restrict by Booking Date (~80% performance improvement)
- Apply filters based on selected date ranges (`BookingDate`, `CancelDate`, etc.) to reduce scanned records.
- Example:
- Search with:
- `BookingDate: 2025-09-25 ~ 2025-09-25`
- `travelerName: AKIHIRO`
- Expected matches:
- `BBBAKIHIRO`
- `TEST AKIHIRO`
- `AKIHIRO LOVE`
- Option 3: Right-side match only (~90% performance improvement)
- Limit `travelerName` search to prefix-based matches (right-side pattern).
- This removes dependency on `BookingDate` but greatly improves efficiency.
- Example:
- Search with:
- `BookingDate: 2025-09-25 ~ 2025-09-25`
- `travelerName: AKIHIRO`
- Expected matches:
- `AKIHIRO`
- `AKIHIRO LOVE`
- `AKIHIRO 123`
- Not matched:
- `123 AKIHIRO`
- `123AKIHIRO`
Updated by ziniy Kang 6 months ago
- Status changed from 진행(Doing) to 피드백(Feedback)
Updated by ziniy Kang 6 months ago
- File picture200-1.png picture200-1.png added
- Assignee changed from ziniy Kang to Tom Dong
Search "Traveler" theo các điều kiện:
+ Các Option phần BK date.
+ Country/Hotel code/Hotel name.(OR)
Updated by Tracy Truong 5 months ago
- File Ohmy Admin and 7 more pages - Work 2 - Microsoft Edge 2025-09-30 08-47-19.mp4 Ohmy Admin and 7 more pages - Work 2 - Microsoft Edge 2025-09-30 08-47-19.mp4 added
- File picture694-2.png picture694-2.png added
- File picture694-3.png picture694-3.png added
- File picture694-4.png picture694-4.png added
- File picture694-5.png picture694-5.png added
- File picture694-6.png picture694-6.png added
- File picture694-7.png picture694-7.png added
- Status changed from QA test to 완료실패(Failed)
- Assignee changed from Tracy Truong to Tom Dong
Admin site: - still slow loading
Set up filter:
1/
BK date: 1 Aug 2025 - 30 Sep 2025
Traveler: MONNGUYEN
=> still display BK from 2023, 2024 & other traveller (Failed)
2/
BK date: 1 Aug 2025 - 30 Sep 2025
Traveler: MONNGUYEN
Hotel Name: Mon Hotel Ba Den Mountain
=> Failed : still display BK from 2023, 2024 & other traveller/ hotel
3/
BK date: 1 Aug 2025 - 30 Sep 2025
Traveler: MONNGUYEN
Hotel Code: 606106
=> Failed : still display BK from 2023, 2024 & other traveller/ hotel
4/
BK date: 1 Aug 2025 - 30 Sep 2025
Traveler: MONNGUYEN
Country: Vietnam
Hotel code: 606106
=> Failed : still display BK from 2023, 2024 & other traveller/ hotel
5/
BK date: 1 Aug 2025 - 30 Sep 2025
Traveler: MONNGUYEN
Country: Vietnam
=> Failed : still display BK from 2023, 2024 & other traveller/ hotel/ BK of other country
Partner site - do not Country/Hotel code/Hotel name filter so only test bk date & traveller condition only
BK date: 1 Sep 2025 - 30 Sep 2025
Traveler: TRACYTEST
=> Failed - display Bk from AUG
Updated by Joseph Vo 5 months ago
- Related to 개선(improvement) #1760: [Admin Site] Improve Admin Site performance added
Updated by Tracy Truong 5 months ago
- File picture386-1.png picture386-1.png added
- File picture386-2.png picture386-2.png added
- File picture386-3.png picture386-3.png added
- File picture386-4.png picture386-4.png added
- File picture386-5.png picture386-5.png added
- File picture386-6.png picture386-6.png added
- File picture386-7.png picture386-7.png added
- File picture386-8.png picture386-8.png added
- Status changed from QA test to 완료(Done)
- Assignee changed from Tracy Truong to Tom Dong
ADMIN:
- Case 1: Only BK date & traveller filter
- Case 2: Filter: BK date, Country, Traveller
- Case 3: Filter: BK date, Country, Hotel name, Traveller
- Case 4: Filter: BK date, Country, Hotel Code, Traveller
- Case 5: Filter: BK date, Hotel Name, Traveller
- Case 6: Filter: BK date, Hotel Code, Traveller
- Case 6: Filter: BK date, Hotel Name, Hotel code, Traveller
*PARTNER:*do not have Country/Hotel code/Hotel name filter so only test bk date & traveller condition only
BK date: 1 Sep 2025 - 30 Sep 2025
Traveler: TESTTEST
Updated by ziniy Kang 5 months ago
- Status changed from 완료(Done) to 확인(Confirmed)
Updated by Tracy Truong 5 months ago
- File Filter BK date & Traveller- Microsoft Edge 2025-10-09 15-06-42.mp4 Filter BK date & Traveller- Microsoft Edge 2025-10-09 15-06-42.mp4 added
- File Case 2 Filter BK date, Country, Traveller- Microsoft Edge 2025-10-09 15-08-46.mp4 Case 2 Filter BK date, Country, Traveller- Microsoft Edge 2025-10-09 15-08-46.mp4 added
- File Case 3 Filter BK date, Country, Hotel name, Traveller name- Microsoft Edge 2025-10-09 15-12-45.mp4 Case 3 Filter BK date, Country, Hotel name, Traveller name- Microsoft Edge 2025-10-09 15-12-45.mp4 added
- File Case 4 Filter BK date, Country, Hotel code, Traveller - Microsoft Edge 2025-10-09 15-15-00.mp4 Case 4 Filter BK date, Country, Hotel code, Traveller - Microsoft Edge 2025-10-09 15-15-00.mp4 added
- File Case 5 Filter BK date, Hotel Name, Traveller - Microsoft Edge 2025-10-09 15-16-48.mp4 Case 5 Filter BK date, Hotel Name, Traveller - Microsoft Edge 2025-10-09 15-16-48.mp4 added
- File Case 6 Filter BK date, Hotel code, Traveller - Microsoft Edge 2025-10-09 15-18-38.mp4 Case 6 Filter BK date, Hotel code, Traveller - Microsoft Edge 2025-10-09 15-18-38.mp4 added
- File picture127-1.png picture127-1.png added
- Status changed from QA test to 완료실패(Failed)
- Assignee changed from Tracy Truong to Tom Dong
Checked on STAG,
ADMIN: Period: 1 -30 Sep 2025 => ok
Case 1: Only BK date & traveller filter
Case 2: Filter: BK date, Country, Traveller
Case 3: Filter: BK date, Country, Hotel name, Traveller
Case 4: Filter: BK date, Country, Hotel Code, Traveller
Case 5: Filter: BK date, Hotel Name, Traveller
Case 6: Filter: BK date, Hotel Code, Traveller
Case 6: Filter: BK date, Hotel Name, Hotel code, Traveller
PARTNER:*do not have Country/Hotel code/Hotel name filter so only test bk date & traveller condition only
BK date: 1 Sep 2025 - 09 Oct 2025
Traveler: TESTTEST
=> Failed - don't have traveller name is "TESTTEST" in this periods but still show BK*
Updated by Tracy Truong 5 months ago
- File Ohmy Partners and 7 more pages - Work 2 - Microsoft Edge 2025-10-13 13-21-37.mp4 added
- Status changed from QA test to 완료실패(Failed)
- Assignee changed from Tracy Truong to Tom Dong
Open new tab > search traveller name that don't have booking > no result => ok
But when click search Bk & Bk list displayed, after that changed traveller name that don't have booking > still displayed old Bk list not change to no result
Updated by Tracy Truong 5 months ago
- File deleted (
Ohmy Partners and 7 more pages - Work 2 - Microsoft Edge 2025-10-13 13-21-37.mp4)
Updated by Tracy Truong 5 months ago
- File Ohmy Partners and 7 more pages - Work 2 - Microsoft Edge 2025-10-13 13-29-56.mp4 Ohmy Partners and 7 more pages - Work 2 - Microsoft Edge 2025-10-13 13-29-56.mp4 added
More details as attached video
Updated by Tracy Truong 5 months ago
- Related to QA #1898: [STAG] Did not record when changed traveller name added
Updated by Tracy Tran 4 months ago
- Status changed from QA test to 완료성공(Resolve)
- Assignee changed from Tracy Truong to Tom Dong
Checked on PROD OK
