Adding Indexing to Improve Report Performance

The dpdbadmin addindex command adds indexing on searchable fields to enhance report performance. If this command is run against your database it will have a minor effect on authentication performance. Increasing the level of indexing will negatively affect authentication performance. For more specific information about report performance with and without the additional indexing, refer to the OneSpan Authentication Server Performance and Deployment Guide.

It may be necessary to go through an approval process in your company before performing this task. You may also need to have a database administrator perform the task for you.

Before you use the command, prepare the following:

• Database name. You need the data source name of the database (as registered with Windows or Linux as an ODBC data source). This DSN must be registered on the computer from which the command line utility will be run.
• Database administrator account. To successfully modify the database structure, you need the username and password of a database administrator account that is able to make changes to the database structure. You must pass these credentials to the utility in the parameters of the command.

To add indexing for report performance, use the following command:

dpdbadmin addindex –u dbusername –p dbpassword -d dsn -level lvl

where:

• dbusername is the user name of the database administrator account.
• dbpassword is the corresponding password of dbusername.
• dsn is the ODBC data source name.
• lvl refers to the level of indexing to apply; this should be 0, 1, or 2

For more information about dpdbadmin addindex, see dpdbadmin addindex.