After you create a new database on the database server, you can configure the database properties.
Right-click the new database node, and select All Tasks > Configure Database Parameters. The Database Configuration dialog appears. It consists of two tabs DBTimer Properties, and DataAccessor Properties.
DBTimer Properties
The DBTimer Properties tab consists of three properties:
Connection Time-Out - Defines how long a connection attempt should wait before time-out.
Command Time-Out - Defines how long database commands should wait before time-out.
Lock Time-Out - Defines how long lock requests should wait before time out.
The above three properties might need to be increased when you experience a large number of time-outs (for example over a slow network or a heavily used resource). This allows AB Suite to successfully complete certain database operations.
Data Accessor Properties
The Data Accessor Properties tab provides us with the option of choosing either Data Readers or Data Sets as the data accessors. By default, the option Use Data Readers is checked, enabling the use of Data Readers, which helps achieve performance compared to the use of Data Sets.
The Data Reader fetches one row at a time and hence is faster compared to the Data Set, which fetches all data from the data source at a time to the memory.
A Data Reader is a preferred choice over a Data Set in scenarios where you need to fetch data that requires no transaction.