medium10 pts · first answer countssystem-designsearch
Search with LIKE is slow
Product search uses WHERE name LIKE '%phone%' on 20 million rows and takes seconds. Users also want typo tolerance. What fits best?
Discussion 0
Join free to post in the discussion.
Related questions
- What a load balancer doesBackend Developer
- Serving images to far-away usersBackend Developer
- The cache-aside patternBackend Developer
- Scaling a read-heavy databaseBackend Developer
- Latency versus throughputBackend Developer
- Estimating requests per secondBackend Developer
- How much downtime 99.99% allowsBackend Developer
- Why keep app servers statelessBackend Developer