🔒 Preview mode. The first 15 Foundations lessons are free; this one is Pro. Start a 7-day trial to unlock the editor, AI hints and the rest of the curriculum. Card required, cancel any time in Dashboard.Start 7-day trial →
📝 **Question:** Autocomplete service takes 200ms p99, users feel lag. Bottleneck is a SQL ILIKE query over a 50M-row table for each keystroke. Best fix?
📋 Pick the right answer.
💡 **Hint:** Re-read the theory above if unsure.
🎯 Quiz
Question
📝 **Question:** Autocomplete service takes 200ms p99, users feel lag. Bottleneck is a SQL ILIKE query over a 50M-row table for each keystroke. Best fix?
📋 Pick the right answer.
💡 **Hint:** Re-read the theory above if unsure.