Tomorrow, August 22 at 10:00am PDT, I’ll present a webinar called Full Text Search Throwdown. This is a no-nonsense performance comparison of solutions for full text indexing for MySQL applications, including:
- LIKE predicates and regular expressions
- MyISAM FULLTEXT indexes
- InnoDB FULLTEXT indexes
- Apache Solr
- Sphinx Search
- Trigraphs
I’ll compare the performance for building indexes and querying indexes.
If you’re developing an application with text search features, this will be a very practical and informative overview of your technology options!
Register for this free webinar at https://www.percona.com/webinars/2012-08-22-full-text-search-throwdown
We evaluated MySql vs Solr.
I was able to index all the data from the db into Solr and make it queryable from a browser within 4 days plus some customization on the search algorithm. It would have taken me 2 to 3 weeks to do something equivalent with MySql and it wouldn’t be as flexible and customizable as Solr. With Solr, I was able to fine tune search and I still feel there are tons of additional features that will help me address future needs.
Hernan