You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This issue was generated using AI, if anything lacks clarity or context, please ask for clarification before starting work.
Summary
The webview re-queries the backend on every change to the search box. Typing a
title sends one RETRIEVE_ACHIEVEMENTS message per character, each of which runs
a multi-join SQL query on the extension side.
Note
This issue was generated using AI, if anything lacks clarity or context, please ask for clarification before starting work.
Summary
The webview re-queries the backend on every change to the search box. Typing a
title sends one
RETRIEVE_ACHIEVEMENTSmessage per character, each of which runsa multi-join SQL query on the extension side.
Location
src/views/components/SearchBar.tsx+src/views/components/AchievementsHolder.tsxSearchBarupdatespartialTitleon everyonChangeand pushes it straightinto
filtersvia auseEffect.AchievementsHolderhas auseEffectkeyed onfiltersthat postsRETRIEVE_ACHIEVEMENTSeach timefilterschanges.So each typed character → new
filtersobject → new query round-trip.Impact
getAchievementsRawFormat, with aCOUNT(DISTINCT ...)whencount: true).of stale results.
Suggested fix
filters.race-induced flicker.
Severity
Low/Medium — UX + avoidable backend work.