I have tried Senna that is an embeddable fulltext search engine. It is embbeded into MySQL.
http://qwik.jp/senna/ I inserted 1,000,000 of documents by using INSERT INTO sql, and I can search documents by using SELECT * FROM table WHERE MATCH(field_name) AGAINST('search-words'). It is based on SQL, so easy to use and support incremental update. I don't do benchmark test yet but it's not slow. I think that the Lucene need to support incremental update futurely. -- Scott
