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
on 2008-11-11 07:14
on 2008-11-11 11:08
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.
on 2008-11-12 19:32
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!