This topic describes how to configure the routing field, the document sorting method for an inverted index, and a timeout period for the search engine.
Configure the routing field
Scenarios and benefits
You can configure the routing field for scenarios in which queries are performed by column.
You can configure the routing field for business that is sensitive to the timeout of queries on a single column.
The routing field allows you to increase the memory of a column to cache hot data. This way, the load on your cluster can be reduced.
Procedure
Go to the details page of the instance that you want to manage. On the Online Application tab, choose Modify Offline Application > Index Schema. On the page that appears, find the Routing Fields (Optional) section.
Select a field contained in the index as the routing field.
Optional. Specify hot values. If the values of the specified routing field are not evenly distributed, we recommend that you specify hot values.
Usage notes
Only one field can be specified as the routing field.
The values of the routing field must be globally unique.
The following data types are supported for the routing field: INT and LITERAL.
The routing field can be configured only for instances of the Exclusive Cluster type.
Configure the document sorting method for an inverted index and a timeout period for the search engine
Scenarios and benefits
You can customize the document sorting method for an inverted index during index building.
After you specify the sorting method of documents for an inverted index, the system ranks the documents with higher quality in front of other documents in the inverted index. This improves query efficiency.
You can configure a timeout period for the search engine for business that is sensitive to the timeout of the search engine.
Procedure
Go to the details page of the instance that you want to manage. On the Online Application tab, choose Modify Offline Application > Index Schema. On the page that appears, find the Advanced Settings (Optional) section.
To configure the Document Sorting Method for Inverted Indexes parameter, click Configure in the Actions column.
In the Advanced Settings panel, select fields in the Field Settings column of the Document Sorting Method for Inverted Indexes section. You can set the sorting method for each selected field in the Sorting Method column to Ascending or Descending. Then, click OK.
To configure the Timeout Period parameter, click Configure in the Actions column.
In the Advanced Settings panel, configure the Timeout Period parameter and click OK.
Usage notes
You can specify only a level-1 field and a level-2 field in the Document Sorting Method for Inverted Indexes section. The following data types are supported: INT, FLOAT, and DOUBLE.
The value of the Timeout Period parameter is in the range of 750 to 1500. Unit: milliseconds.
You can click Restore Defaults in the Actions column to restore the Document Sorting Method for Inverted Indexes or Timeout Period parameter to the default settings.
Advanced settings can be configured only for instances of the Exclusive Cluster type.