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