Home → Installation and Upgrade Manual → HelpSpot 4 - Installation & Setup → Database Based Full Text Search

10. Database Based Full Text Search

AS OF HELPSPOT 5.0.X SPHINX SEARCH HAS BEEN COMPLETELY REMOVED

As of version 4.6.7 HelpSpot allows the use of either built in database full-text search of the use of the external Sphinx search indexer. New installations will default to the database search search option. To switch an existing sphinx based installation to database search you simply need to add the define('SEARCH_ENGINE', 'database'); variable to your config.php file.

Opting For Sphinx Search:
Most installations will be well served by the default, database Full Text search option. However, if there is a need for advanced full text search parameters or a need to reduce the database load query load, Sphinx search can be setup. On linux bases installs, the sphinx setup requires additional steps that are documented here: for Ubuntu/Debian and RedHat/CentOS. New windows installations will default to database search but can be converted to sphinx search by changing the config.php
variable for the search engine to define('SEARCH_ENGINE', 'sphinx');.