Thread:User talk:MWJames/Search results sorting/reply

Thanks for effort, right now we are testing and it looks good. Maybe their should be a note that this change will impact the index time since the main index will take around four to five times longer to build the index.

For the incremental index we changed to DATE_FORMAT(CURRENT_TIMESTAMP - INTERVAL 12 HOUR, '%Y%m%d%h%i%s') to minimize the incremental index time while running the merge function more often.

/path/to/sphinx/bin/indexer --config /path/to/sphinx.conf --rotate --merge wiki_main wiki_incremental --merge-dst-range deleted 0 0