3 ms·
No, there is no incremental mode to the indexer, but that doesn't mean it can't be done. Create a counter table to keep track of what records you've indexed an
by brndnhy 16y ago
No, there is no incremental mode to the indexer, but that doesn't mean it can't be done.
Create a counter table to keep track of what records you've indexed and cron frequent indexer runs using the latest records as offsets.
If you have documents that frequently change, maintain your full index less often and instead merge the two on a more regular basis.
Sphinx's indexer speed is one of its advantages, but it's largely dependent on the efficiency of your SQL and underlying MySQL indices. Perhaps something else is indirectly influencing your indexing performance.