main index + realtime index combined

[J. Garcia]

Is it possible to have a setup with a main index for stable mysql data plus a realtime one for updates?

How would this have to be wired in Rails?

Did anyone experiment with this?

J.

[Pat Allan]

This isn’t an option currently, though it’s certainly been discussed - and there are features under the hood in Sphinx that would allow for it.

https://github.com/pat/thinking-sphinx/issues/832

Is there a reason you wouldn’t use real-time indices only? I’ve been using it for several apps lately and haven’t hit any issues.

— 

Pat

--
You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thinking-sphi...@googlegroups.com.
To post to this group, send email to thinkin...@googlegroups.com.
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.

[J. Garcia]

Hi Pat,
Thanks for your response.

I've finally abandoned this option in favour of a main index plus default (immediate) delta, as I do not expect many frequent deltas for this particular index.

However, I'm having a problem with the configuration of the sql_query_post_index. I need a custom delta column name. There seems to be a :column option in ThinkingSphinx::Deltas::DefaultDelta but cannot figure out how to use this in my index definition. Any tips for this?

J.

--
You received this message because you are subscribed to a topic in the Google Groups "Thinking Sphinx" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/thinking-sphinx/Eq0tOMQcKzo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to thinking-sphi...@googlegroups.com.

[Pat Allan]

The following should do the trick:

  ThinkingSphinx::Index.define :model, :delta => true, :delta_options => {:column => :foo} do

    # …

  end

— 

Pat

[J. Garcia]

That worked, thanks!