Hmm, so you're using a view as the basis for a model? Is there a datetime column that indicates when a record in the view is changed? Because it might be worth looking into a fork that provides some options for datetime-based deltas (instead of using the boolean column of the same name). http://github.com/bassnode/thinking-sphinx/tree/master http://blog.edhickey.com/2008/09/15/thinkingsphinx-rails-plugin-fork/
It's worth noting that the fork isn't quite up to date with my repo. This - or something very similar - will be merged into TS at some point, I'm just not sure when, unfortunately. Cheers -- Pat On 18/12/2008, at 1:29 AM, Canvas wrote: > > Hi , > > I have a very complecated view to search data from. The view joins 6 > tables, incuding inner and outter joins. Triggers are used to update > data to help the join when data in the 6 tables are updated. As a > result, the view is very complicated. > > I used thining_sphix to build index and searched on the view, it > worked pretty nice. But since it’s a view, I can not add column > “delta” into it and can not use the delta index as a result. But I > really need to use delta index as my data updates quite often. > > The solution I can think of now is to use a table to replace the view. > And update data into the new table when any of the 6 related tables > are updated. Therefore I have to extract the logic in the view and > triggers and implement it somewhere. The side effect of this solution > is that synchronize the data in the new table and the other six is > quite messy. > > Any suggestion will be appreciated. Thank you very much. > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
