Tag - FullText Search

Sphinx search performance optimization: attribute-based filters

One of the most common causes of a poor Sphinx search performance I find our customers face is misuse of search filters. In this article I will cover how Sphinx attributes (which are normally used for filtering) work, when they are a good idea to use and what to do when they are not, […]

Read more

Webinar for Full Text Search Throwdown

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 […]

Read more