Hi Wolfgang,
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,
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
