Upgrading alpha version Faceted Search

Upgrading alpha version Faceted Search

When upgrading an alpha version of Faceted Search to the current version, take into account that the chosen SearchGroups CTFP architecture will be overwritten, meaning that the old STANDARD SearchGroup will be replaced by default SearchGroups like PUB, CMS and SXML. As long as the stored procedure pr_TextSearch is not invoked, this will have no effect on the used indexed view. Changes in the view should be made manually. Don't forget to re-index the indexed view manually as well.

Removing alpha version Faceted Search database objects

Alpha version (and even prior versions) Faceted Search uses a couple of database objects of which some of them are equally named as the current version of Faceted Search. In order to successfully install the current version of Faceted Search, the old database objects are renamed during installation:

Stored Procedure pr_TextSearch --> pr_TextSearch_DROP_ME
Table TsSearchGroups --> TsSearchGroups_DROP_ME
Table TsSearchGroupsCTFields --> TsSearchGroupsCTFields_DROP_ME

Of course, corresponding database constraints like primary and foreign keys will be renamed accordingly.

It's good practice to manually drop these renamed objects after it is confirmed that the current version of Faceted Search is properly installed and fully functional.

SQL	Copy Code
/* Run these if you choose to drop the old database objects prior to running the setup */ DROP PROCEDURE pr_TextSearch; DROP TABLE TsSearchGroups; DROP TABLE TsSearchGroupsCTFields; -- /* Run these if you choose to let the old database objects be renamed */ DROP PROCEDURE pr_TextSearch_DROP_ME; DROP TABLE TsSearchGroups_DROP_ME; DROP TABLE TsSearchGroupsCTFields_DROP_ME;

Alternatively, pr_TextSearch, TsSearchGroups and TsSearchGroupsCTFields can be dropped prior to running the Faceted Search setup.

Note that neither pr_TextSearch nor pr_TextSearch_DROP_ME should be invoked after installation of the current version of Faceted Search.

The main advantage of letting the setup script rename the legacy database objects is to be able to restore the old objects, uninstalling the current version of Faceted Search.

It is be possible to have two Full Text Search modules functionally in one iXperion site. However, the old version's indexed view will be 'frozen', meaning that CTFP changes will have no effect on the indexed view automatically. It is allowed to alter this indexed view manually, however it is recommended to use only the current version of Faceted Search explicitly. Furthermore, it is recommended to drop the index for performance reasons if the old version's idexed view is to be fully replaced.