Add search that isn't useless
LIKE '%query%' is a prototype, not a feature.
Users need to search <what>. Roughly <n> records, growing to <n>. Start with the simplest thing that will be good enough at my size, and tell me the point at which it stops being good enough. Handle, at minimum: partial words, different capitalisation, extra whitespace, and a query that matches nothing. Show me the empty state. Do not reach for a search service unless my numbers actually need it.
Ask for the threshold. Knowing "this breaks past about 50,000 rows" turns a future emergency into a calendar entry.