I’m looking for a good way to search a few fields accross multiple
asociated tables (i.e. find ‘friends and family’ accross Photo.name,
Photo.description, and Tags.name where Photo has_many tags). And,
ideally there’s a competent query analyzer/parser.
I’ve expirimented with constructing my own SQL using … LIKE %term1%
… etc, but the performance is poor – queries take seconds or more
depending on the number of terms.
Will acts_as_ferret work for me? Any recommendations?