Tell me more ×  I have a mysql database where large amounts of
text are constantly added. (10 pages of text per hour). Text is
stored as plaintext in text fields. Every row contacts a page or
two of texts.  I need to do full text search (search for a
keyword in the text and do complex queries) on this database on
a regular basis. I just need to search for newly added text. But
it is very important for added text to be immediately searchable
(within a minute or two).  From what i've read, fulltext with
mysql is very inefficient. I know lucene is an option but i'm
not sure yet how quickly it can index new text.  So what are my
options? is there a way to make mysql more efficient? is lucene
my best solution? anything more appropriate?   share|improve
this question add comment  2 Answers  up vote 1 down vote
accepted  I have done benchmarking for Indexing Times for Sphinx
& Solr. Sphinx is far ahead as compared to Solr with respect to
Indexing Algorithms (super fast indexing times and small index
size).  When you