Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database reference » UltraLite options

UltraLite kdf_iterations creation option

Specify the number of iterations, in thousands, for the key derivation function that converts the pass phrase provided by the DBKEY option into an actual encryption key.

Allowed values

1 to 1000


The default value for Apple Mac OS X and iOS is 30, which results in 30000 iterations.

The default value for other platforms, including desktop and device platforms, is 5, which results in 5000 iterations.


This parameter is specified only at database creation.

The key derivation function makes it more difficult to access an encrypted database by prolonging each attack attempt.

Note A larger number of iterations will make passwords harder to break through brute force, but will increase database start-up time.

There are two cases when an explicit setting may be required:

  1. You are using a very slow device and UltraLite takes too long to start with encryption. For example:
  2. You are using a high-end computer and want added security. For example, when running UltraLite on a Windows or Linux desktop: