How to do indexing with Sphinx?

Question

Yii

There was a small question
. New data is constantly entered into the database, and the question arose of how to index them correctly, give the entire table to Sphinx ... but I think it's better to make a query starting from the last record of the last indexing!
Am I right !?

Answer 1

You are calling isAttributeRequired on an object which is null.

Answer 2

Read about delta indexes.
This is exactly what you need in your situation.
The approximate essence is as follows:
There is a main index that is rarely indexed (this is a full indexing of the entire table)
There is a delta index that is indexed frequently (this is an indexing of new or changed records)
The search is carried out on both indexes