Enabling Parallel Indexing 

Use

You can optimize the filling of BIA indexes by enabling parallel indexing, which improves performance of the BI Accelerator. The number of threads for indexing can be configured, which enables the TREX index server to index attributes of a BIA index in parallel.

Prerequisites

You have installed BIA 7.0 Revision 44 or higher.

Procedure

The parameter for configuring and enabling parallel indexing is tmpx_threads. You customize the tmpx_threads parameter in the TREX configuration file TREXIndexServer.ini. You do this using the TREX admin tool in the SAP system (transaction TREXADMIN).

...

       1.      Start the TREX admin tool in the SAP system (transaction TREXADMIN).

(Or start the SAP NetWeaver BI Accelerator Monitor (transaction RSDDBIAMON) and navigate to the menu entry: Goto  ® TREX Administration Tool.)

       2.      Navigate to the Ini Files tab.

       3.      Open the TREX configuration file TREXIndexServer.ini by double clicking it.

       4.      In the [indexing] section configure the tmpx_threads parameter:

[indexing]

tmpx_threads=<new_value>

Value 1 means single-threaded. If you increase this parameter, more CPU cores are used in parallel to fill each BIA index. If you do an initial filling of your BIA and fill the BIA indexes sequentially, we recommend increasing the tmpx_threads parameter to the value 8 for quad core CPUs.

The tmpx_threads parameter is set to value 1 by default, which means that the performance as of BIA 7.0 Revision 44 is by default the same as in previous BIA revisions.

       5.      Choose Save to all hosts to publish the changed TREX configuration file TREXIndexServer.ini to all blades in your BIA landscape.