Im switching fulltext searching on my site to sphinx. Im going to be using SphinxSE to perform the searches.
I created 2 indexes, as specified in the manual: http://www.sphinxsearch.com/docs/manual-0.9.9.html#live-updates
It seems to work, and index different stuff in its own index, but Im somewhat confused about how I should handle the index updating, merging, and rebuilding.
The way I understand is I cron it to run "indexer delta --rotate" every 5 mins or so, which would add new submissions to the index. Then once a day, I would merge the delta index into the main index by running "indexer main delta --rotate". then once a month or so, I'll run "indexer --all" to rebuild all indexes.
Am I doing this right, or am I missing something?