Enable query cache

Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

For system performance consideration, Service Manager enables the query cache by default. When the query cache is enabled, Service Manager creates a cache table in the Production Database to save query results and the query SQL. Both the queries against the Production Database and Replicated Database are all saved in the cache table

Note When the query result is expired or you refresh the report or dashboard, Service Manager will retrieve the data by executing the query from the Production Database or Replicated Database again.

To enable the query cache, follow these steps:

Open the sm.ini file. By default, the file is located on the Service Manager server in the C:\Program Files (x86)\Micro Focus\Micro Focus Service Manager 9.50\Server\RUN folder.

Enter the query cache parameters and values in the file. Service Manager enables query cache by default and the default values for the parameters are shown as follows: