Third time I've written this - Google Groups keeps losing my posts after I click send.... or maybe they'll all show up an hour later. :(
Wouldn't it be more efficient to use attributes instead of searchable fields for strings? Is that supported? I get this error when I try to do that: Cannot automatically map attribute listing_type in SourceListing to an equivalent Sphinx type (integer, float, boolean, datetime, string as ordinal). You could try to explicitly convert the column's value in your define_index block: has "CAST(column AS INT)", :type => :integer, :as => :column On Jul 10, 12:14 pm, Pat Allan <[email protected]> wrote: > Hi Alex > > You can create the query string yourself instead of using > the :conditions hash: > Model.search "cats @city seattle @region see", :match_mode > => :extended2 > > Cheers > > -- > Pat > > On 10/07/2009, at 3:08 PM, Alex wrote: > > > > > > > In response to a performance issue, it was suggested that I make sure > > the most selective filters are used first, since Sphinx is apparently > > not smart enough to do that automatically like a SQL database normally > > would. TS seems to use a hash, so this doesn't seem possible right > > now. > > > Any suggestion on where the best place to hack in a fix might be? > > > The post: > > >http://sphinxsearch.com/forum/view.html?id=3888&new=1 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
