Skip to main content
← CoursesSystem Design for Python JuniorsModule 4 · Messaging, Streaming, MicroservicesDesigning search autocompletequiz52 / 101
💬 Discuss🧪 Playground+150 XP
Task
📝 **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.

Keep going

🎯 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.
📣 Help someone learn PythonShare this lesson with a friend — the first 15 are free, no signup.Tweet

💬 Discussion

Be the first to ask a question or share a tip.
Sign in to join the discussion. Reading is free.
Loading discussion…