Rebuild indeces on database tables
ADIF imports and rescan of indicators via the command line tool RescanIndicatorsConsole.exe or via the Job Scheduler functionality may trigger a high number of single database insert and delete transactions. This can have a negative impact on fragmentation of indices. As a result, CPU usage is increased and performance is reduced. It is recommended to rebuilt indices in regular intervals for object classes subject to ADIF import or rescan of indicators.
To rebuild indices for a number of object classes defined by object class name, use the following command line for the AlfaAdministratorConsole.exe:
- AlfaAdministratorConsole.exe -msalias <alias name> -alfaLoginName <Alfabet user name> -alfaLoginPassword <user password> -rebuild_indices -class_names <comma separated list of object class names>
To rebuild indices for a number of database tables identified by table name, use the following command line for the AlfaAdministratorConsole.exe:
- AlfaAdministratorConsole.exe -msalias <alias name> -alfaLoginName <Alfabet user name> -alfaLoginPassword <user password> -rebuild_indices -table_names <comma separated list of database table names>
To rebuild indices for all database tables, use the following command line for the AlfaAdministratorConsole.exe
The table below displays the command line options:
| Command Line Option | Mandatory/ Default | Explanation |
|---|---|---|
| -rebuild_classindices | Mandatory | To rebuild indices for database tables in the Alfabet database, start the console application with
|
| -class_names <comma separated list of object class names> | It is mandatory to specify either -class_names , -table_names , or -all | Define the object classes for that an index shall be rebuild as a comma separated list of object class names.
For example:
|
| -table_names <comma separated list of database table names | It is mandatory to specify either -class_names , -table_names , or -all | Define the database tables for that an index shall be rebuild as a comma separated list of database table names.
For example:
|
| -all <TRUE/FALSE> | It is mandatory to specify either -class_names , -table_names , or -all | Add this command line parameter and set it to TRUE to rebuild all indices. |
| -msalias <alias name> | Mandatory | Enter the server alias name as specified in the AlfabetMS.xml configuration file for access to the database. |
| -msaliasesfile <Alfabet configuration file path> | Optional | If the AlfabetMS.xml configuration file that contains the specification of the alias is not located in the same directory as the executable, the path to the AlfabetMS.xml file must be specified with this parameter. |
| -alfaLoginName <Alfabet user name> | Mandatory | Alfabet user name of a named Alfabet user for login.
A user can only execute a batch job if the Can Execute Batch Jobs checkbox is selected (=True) for the user. |
| -alfaLoginPassword <user password> | Optional | Alfabet login password. |