Ruby on Rails

Hi all. It's time to choose a search system for a new app i've been
working on and though i'd crowdsource some wisdom. I've used
ferret/acts_as_ferret before and encountered some problems which make me
reluctant to use it again. I know people are using sphinx/solr these
days (and other things i'm sure).

My particular requirements are to do with complex joins: when i do my
search i'm joining lots of tables together and passing various
conditions to do with the join tables, using a search term (which at the
moment is just doing a LIKE match on a keywords field), sorting by one
of the joined fields, and of course paginating the results. Obviously,
LIKE searches on a text field isn't very scalable (especially in innodb
mysql which doesn't allow full text indexing) and it's this aspect that
i need to replace with a proper indexed search system.

It was the combination of searching, sorting, joining and paginating
that seemed to cause problems for ferret and i wondered if anyone could
recommend a search system that works well with this sort of usage.

Sorry if that's a bit vague, just looking for some accounts of
experiences really. Grateful for any advice - max
--
Posted via http://www.ruby-forum.com/.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.