Search multiple tables


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.



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.

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!