Optimize CDB - adjust feature indexes

Adjust the indexes in the censhare database (CDB). Use config.xml (AssetStore).

Skip arbitrary features in the index

You can switch off the indexing for certain features. You are also able to prevent applying the values for word frequency and document length in a full-text index. As a censhare administrator, you can take this into consideration: to prevent the memory requirements (database cache) and the database size to grow uncontrollably.

The use-frequency option is disabled only for the metadata (text.meta and text.name). For these two indexes, the relevance has little to do with the ratio of hits and document length, so there are really no disadvantages, but rather better predictability of the results.

The censhare full-text index, where the "DocLength" is significantly more important, continues to use frequency.

Configuration

Edit the XML file /app/services/assetstore/config.xml" and make the necessary or desired adjustments for your specific case.

CODE

<fulltext><index ... use-frequency ="false"/> <index name="..." disabled="true"/>

To disable a feature index in the censhare Admin Client:

In Configuration - Embedded Database, activate Disable this index.

Due to the changes made in the database configuration, a rebuild of the CDB is required. The relevance of search results is now calculated a bit less accurate, but this is absolutely tolerable.

See also Wikipedia: Approximate string matching