> > I'd definitely use an attribute (has) instead of field (indexes) - > Sphinx will be doing a straight compare instead of using its textual > searching mechanisms, which I'm pretty sure would add some extra > overhead.
thanks Pat. I was pretty sure it was worth asking :) cheers! -- Thibaut > > > Cheers > > -- > Pat > > On 03/02/2009, at 8:44 PM, Dan Pickett wrote: > > > I'm using true - not sure of any serious perfomance considerations > > here as the casting/prep for sending the filter to Sphinx happens in > > Thinking Sphinx and Riddle. > > > > On Tue, Feb 3, 2009 at 8:08 AM, Thibaut Barrère < > [email protected] > > > wrote: > > > > Hello, > > > > I'm wondering what most people do to filter by a boolean attribute. I > > have a checkbox in my UI. If it's checked, then I need to only include > > items with the attribute set to true. > > > > Partner.search(:with => { :my_boolean => true }) # has :my_boolean > > > > or > > > > Partner.search(:conditions => { :my_boolean => 1 }) # > > indexes :my_boolean // true doesn't work here > > > > seem to work both. > > > > I tend to prefer the first option. I'm not sure what are the > > implications (performance, size etc). > > > > What do you use ? > > > > -- Thibaut > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
