Faster Catalog Search
Keeping catalog search and large checklists fast as the catalog grows to millions of cards.
- Status
- In Progress
- Last updated
Overview
The catalog has grown from about 580,000 to well over two million card records. Name search checks the fast start-of-name match first and widens only when needed, card numbers sort naturally on the server, and heavy counts are precomputed instead of calculated on every page load. Search that matches text anywhere in a name still needs database support that isn't in place yet.
Completed work
- Name search tries the fast start-of-name match first
- Card numbers sort naturally on the server instead of in the browser
- Category and sport counts are precomputed so pages don't wait on them
- Card search within a sport
Milestones
- Completed
Prefix-first search and server-side natural sort
- Completed
Precomputed catalog counts
- Not Started
Search and sort indexes
What “done” means
The outcomes this item has to deliver. Each is marked as it is confirmed.
Start-of-name search uses an index
Met
Counts don't slow page loads
Met
Search for text anywhere in a name stays fast at full catalog size
Not met yet
Large set checklists load quickly
Not yet verified
Development updates
No development updates have been posted yet.