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-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.