Hi Canvas The delayed_delta approach still requires the boolean field, so that's not going to work out for you.
I think the best option at the moment, if you want something continuous, is set up a script that runs constantly, looping on something like the following: loop do `rake thinking_sphinx:index:delta` sleep(2) end Which will take a two second break after every index. You could then also set your threshold down to, say, 1 minute. This will keep your delta indexes pretty small. You should be able to do this with my version or Ed's fork. Cheers -- Pat On 06/01/2009, at 4:03 AM, Canvas wrote: > > Hi Jorg > > I call delta-indexing manually only on my development machine for > testing purpose. It's actually called automatically in a backend > daemon roughly every 20 seconds. I came up with a new rake command > "thinking_sphinx:delta_and_merge" which calls "ts_index(index, true)" > and "ts_merge(index)". It seems working fine now. But I am not sure > this is the correct approach or not. Thanks. > > > Hi Pat, > > I can not go with the default setup because I am using views instead > of tables, I can not add a updatable "delta" column into a view. As > for delayed_job approach, does it support the timestamp based delta > index on a view? Can you please explain a little bit how the delayed > delta approach works? If the delayed delta approach meet my > requirement, I will for sure switch back to the newest main version. > Thank you very much for your information. > > > > Cheers, > -- > > Canvas > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
