Sphinx Search

[Simetrical]

Originally Posted by ivanp

Not really sure if indexes should be dropped.

I think other functions such is "Similar threads" depend on it. Should be checked.

If you don't drop the indexes, you'll lose a good part of the benefit of switching to Sphinx (although you'll keep most of it, it's true). The indexes are very large and keeping them up-to-date will add to server load unnecessarily. Although not half as much as the locks that conducting the actual searches takes out.