13.2.2. Full-text search
Full-text search is a feature that can be enabled in MS SQL to
improve the performance of searching, especially across large quantities
of text. If full-text catalogs are enabled on your database, you can
activate this feature in the back end of Kartris. Navigate to
Configuration > Database Admin and then the
FTS tab. Click the link to enable the feature, and it
should confirm the various languages it is supported
for.
The process of activating FTS also creates a new stored procedure - spKartrisDB_SearchFTS (and a corresponding back end one called _spKartrisDB_AdminSearchFTS). These are used in place of the normal search stored procedures on sites where FTS is enabled.
The benefits of FTS are really felt on a large site with more than 10,000 products. For sites upwards of this, FTS is almost essential as conventional searching will become slower and slower the more data there is.
The process of activating FTS also creates a new stored procedure - spKartrisDB_SearchFTS (and a corresponding back end one called _spKartrisDB_AdminSearchFTS). These are used in place of the normal search stored procedures on sites where FTS is enabled.
The benefits of FTS are really felt on a large site with more than 10,000 products. For sites upwards of this, FTS is almost essential as conventional searching will become slower and slower the more data there is.
