Ruby on Rails

Max Williams wrote:
> 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.

Then don't use InnoDB. Switch to PostgreSQL, which (among other
advantages) allows full-text indexing and referential integrity on the
same table.

I don't see why you need a search plugin here at all.
>
> 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.