Search multiple tables


#1

Hi,

I am trying to create a search feature that queries multiple tables,
and returns results from all tables in a single paginated query, kind
of like the search feature on facebook. I was wondering if there are
any good ways to do this.

Thanks

Bob


#2

This may depend on the actual number of tables to search,
and on the kind of search.

If it’s only two or three, I would go for ActiveRecords :join
or :include
If that gets too complicated I would use pure SQL.
Another option would be a search engine like sphinx.


#3

Thanks. I just gave ultrasphinx a try, and it looks promising. I’m
also considering looking into solr.

Do you have any advice as to how the two stack up?

Thanks again!