This section allows adjusting full-text search performance on Oracle databases. To modify these settings you need to have administrator privileges.
To access the settings open the following URL in your browser http(s)://<your_collabserverURL:port>/ui#admin: and click the Search tab.
The Search tab is available on Oracle databases only.
About Search on Oracle Databases
Historically, all databases supported by Collaborator use regular expression matching for full-text search in reviews. Each time a search term is specified, Collaborator makes a regular expression query and returns matching results. This approach provides suitable performance for small and moderate databases. Yet on huge Oracle databases, especially when multiple custom fields are used, regular expression query could take significant time to complete.
As an alternative to regular expression query, you can install the CTX_DDL PL/SQL package on your DB server and use dedicated Oracle text component for text search. It generates and keeps its own indices and thus performs much faster than regular expression search. However it needs additional efforts to keep Oracle text indices synchronized with the rest of database.
Context Indices Settings
These settings affect what type of indices your Oracle database should use for full-text search and how often they should be synchronized.
|Use Oracle Text search instead of regular search||Specifies whether to use Oracle Text component, or regular expression query to perform full-text search form Web Client.|
|Indices sync type||
Specifies when to perform synchronization of Oracle text indices. Possible values are:
Specifies the interval for periodic synchronization of Oracle text indices. Possible values range from 5 minutes to 24 hours, including custom value using calendaring syntax. For example,
Appropriate sync interval allows finding a balance between accuracy of search results and DB server load. Say 24 hours interval will have minimal impact on DB server, but will not find text added in the last 24 hours. Whereas, 5 minute interval provides minimal delay, but generates significant load.
To apply the settings press the Apply changes button.
Context Indices Maintenance
This section allows to start indices maintenance operations manually.
To start synchronization or optimization, schedule them using the controls above, specify desired parameters and then press the Apply changes button.