Database Settings - Details

Parameters for database access:

• Database: The database host name and name as host\database.
• Database User: If standard login is used for database access, enter the user name of the database login user.
• Database User Password: If standard login is used for database access, enter the password of the database login user.
• Database Access: During critical administrative operations like update of the meta-model or restore of the database the database is set to restricted mode. If your database server or the access permissions granted to the Alfabet components does not allow the Restricted mode to be set, set this attribute to State . During update of the meta-model, the state Updating will be used instead to block access for other applications.

Database connection parameters:

Alfabet uses SQL server connection pooling for connections to the database server. With connection pooling, all requests are handed over to a pool of persistent connections.

• The minimum number of connections are allowed in the connection pool: Enter the minimum number of concurrent connections allowed in the connection pool. The minimum value must be 1 during update of the meta-model via AMM file or database restore from ADBZ file. For performance enhancement of the Alfabet Web Application the value can be set to 10 or higher in production environments.
• The maximum number of connections are allowed in the connection pool: Enter the maximum number of concurrent connections allowed in the connection pool. It is recommended to use the default value already set for new server aliases.

  The limitations of the operating system must be considered. On Microsoft® Server hosts the maximum number of connections should not be higher than 30000

• Encrypt Connection: Select the checkbox to apply SSL to the connections between the Alfabet component and the Alfabet database 

Parameters for database maintenance:

• Rebuild fragmented indices on server start: This parameter is evaluated in the server alias configuration of the Alfabet Server only: Select the checkbox to activate rebuilding of fragmented indices on each start of the Alfabet Server. Adding data to and deleting data from database tables leads to database index fragmentation which has a negative impact on performance.
• Clean invalid characters from strings during reading and writing: Select the checkbox if you want strings to be checked for validity prior to check-in or when reading the string from the Alfabet database. Invalid characters such as special characters that are not allowed in the string are cleared from the string and the string is written to the database and displayed in the Alfabet user interface without the special characters.

  This option can cause a loss of performance. The checkbox should only be selected if problems with special characters have been detected.