All threads / How to Efficiently Search for 1milion+ Users in Postgresql and Rails?
Ask A Question

Notifications

You’re not receiving notifications from this thread.

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

Denis Omerovic asked in Databases

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

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

Join 70,078+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.

    logo Created with Sketch.

    Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more. Icons by Icons8

    © 2023 GoRails, LLC. All rights reserved.