at least ferret will work perfectly well for you.
Let your photo-model 'acts_as_ferret' and make acts_as_ferret index a method named eg 'all_tags' which returns a comma (or tab or whatever) seperated string of your tags on this photo. Now you'll be able to constructs a query as described in the rdocs of the QueryParser of ferret that includes your tags and should be very performant.
Cheers,
Jan
On 7/2/06, Wolfgang Borgon <[EMAIL PROTECTED]> wrote:
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?
Thanks!
--
Posted via http://www.ruby-forum.com/.
_______________________________________________
Ferret-talk mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/ferret-talk
_______________________________________________ Ferret-talk mailing list [email protected] http://rubyforge.org/mailman/listinfo/ferret-talk
