Project

General

Profile

Actions

Improvement #30581

open

Improvement #29635: Code Review, Upgrade and changes in Prompt of Email Boat

Optimization: Pre-Index Airline Cache for Faster Fuzzy Matching

Added by Sachin Suresh 5 months ago. Updated 5 months ago.

Status:
Fixed not Tested
Priority:
Normal
Assignee:
Target version:
-
Start date:
11/28/2025
Due date:
11/28/2025 (about 5 months late)
% Done:

100%

Estimated time:
2:00 h
Spent time:
remarks:
DB Changes:
Keys & Permissions:
Areas Affected:
Files Changed:

Description

The airlineService.js currently fetches all airline data into an array (airlineCache) and performs fuzzy string searching (splitting the query into tokens, lowercasing, and checking containment) directly on this array every time getAirlines(query) is called.

For large airline datasets, this linear search can introduce performance bottlenecks and increase API latency. We need to restructure the cached data for near-instant lookup by name or code.

Actions

Also available in: Atom PDF