Hi Mike The issue is a limitation in Sphinx itself - the ordering only works within an index (and since you're using deltas, the record that's changed exists in the delta one, whereas everything else is in the core).
The latest Sphinx and TS releases have a fix for this - if you use Sphinx 2.0.1 (or compile from SVN if you're on a Mac) and TS 1.4.6, it should use a better sorting approach. Give it a spin, let us know. Cheers -- Pat On 14/07/2011, at 4:45 AM, mikej wrote: > Really confused here. > > in my model: > > define_index do > set_property :delta => true > indexes title, :sortable => true > has status_id,city_id > has category_id > has city.city, :as => :city > end > > also tried: > > Model.search nil,:order => :title > > looks fine. > > When you edit a record in the console or app it appears first in the > search until you re index. > > Using thinking-sphinx 1.3.20 > > Really sorry if I'm doing something daft. Been googling for ages and > never had this problem. > > Many thanks, > > Mike > > > > -- > 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. > -- 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.
