How to Efficiently Search for 1milion+ Users in Postgresql and Rails?

Denis Omerovic asked January 26, 2022 12:19pm in Databases

Denis Omerovic January 26, 2022 12:19pm

I have a user model and around 1milion user records in my database and I'm using ILIKE to match the users by name or email. Sometimes it's very slow since I have a lot of records in my DB so I'm looking for a better way to search users. I would appreciate any suggestions.

Join the discussion

Create an account Log in

Courses

Rails for Beginners

Advanced Ruby: Behind the Magic

Payments with Rails Master Class

Refactoring Rails

Apps

Hatchbox.io

Jumpstart Rails SaaS Template

Other

Remote Ruby Podcast

Rails Hackathon

Beginner Bounties

Ruby on Rails Job Board

Notifications

How to Efficiently Search for 1milion+ Users in Postgresql and Rails?

Want to stay up-to-date with Ruby on Rails?