KM full text search using sphinx. Use "NO ZODB" approach -i.e. search results are delivered entirely by MySQL backend together with text excerpts from Sphinx search engine. See http://www.erp5.org/HowToUseSphinxSE