Developer takes down own search after vector queries overload database
A developer building a recommendation-style search site reports a week of trouble after a batch job recomputing similar-title lists ran against the same small database that serves user searches. Search began failing with timeouts, and the cause turned out to be a forgotten experimental vector set stored in the shared table, which slowed filtered queries. The developer added request deadlines, resumable batch runs, and reduced concurrency, and moved the parked experiment's data out of the production table. A separate issue arose when searches for animated titles returned live-action films, prompting a new explicit format field derived from TMDB genre tags.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in