Sphinx

The support of Sphinx for the MySQL fulltext search can speed up ke_search queries. This is useful particularly for large search indexes.

The perfomance depends on the server that is hosting ke_search. On some machines Sphinx can be useful with 1.000 index entries. On other hardware the performance is possably still quite good using the standard MySQL index with 10.000 index entries.

An additional benefit is the ability to make use of the “in-word-search” capabilities of sphinx (see below).

Restrictions

There are some restrictions to take into account if you want to use the Sphinx feature: