Thinking Sphinx and lack of updated records

Question

We are running thinking sphinx on a utility instance in our server cluster. It is rerunning the index every minute. But, if you make a change to a record, it disappears from search results until the index is updated (up to 1 minute).

Is Thinking Sphinx only returning rows that have updated_at times that less than their last index?

If so, how can I get db changes to update the TS on the utility instance?

Answer 1

Instead of re-indexing every minute try using the Delayed Deltas approach. It is designed to tide over your search results until you fully re-index.

See:

http://freelancing-god.github.com/ts/en/deltas.html