Good morning Pat, I do have delta-indexing etc enabled, but the order is also 'wrong' after doing a full reindex...
Let me know in case you need more data/input. Cheers, -J On Jan 4, 7:44 am, Pat Allan <[email protected]> wrote: > Hmm, if Sphinx doesn't like the sort statement, it doesn't return > anything. But it sounds like you're getting results, so it should be > doing the right thing. > > The issue could be related to delta indexes? From memory, I think > Sphinx orders by index, *then* by attribute, so anything in the delta > comes after core. I'm not entirely sure of this, mind you, and there > should be ways around it by merging delta into core, but I was playing > with that last night and results weren't quite what I was expecting, > so it's not part of the public release just yet. > > I will investigate further. > > Cheers > > -- > Pat > > On 01/01/2009, at 12:05 AM, Jörg Battermann wrote: > > > > > > > Hola :) > > > Quick Q: I just noticed that my search results are not sorted by > > created_at DESC, even though my options look like this: > > > �...@search_options = { > > :page => (params[:page] || 1), > > :per_page => Question.per_page, > > :include => :user, > > :order => "created_at DESC", > > :match_mode => :extended > > } > > > @questions = Question.search((params[:search] || ""), @search_options) > > > The Index definition looks like this: > > > define_index do > > indexes title, :sortable => true > > indexes cached_plaintext_question, :as => :question > > indexes answers.cached_plaintext_body, :as => :answers > > indexes cached_tag_list, :as => :tags > > indexes user.name, :as => :user > > indexes answered_by, user_id > > > has created_at > > has answers(:id), :as => :answer_ids > > > set_property :delta => true > > end > > > :-/ > > > Any idea why this is happening? > > > Cheers and happy new year to everyone! :) > > > -J --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
