It is important to configure and then review the Advantage Database Server's database configuration settings in order to avoid client side run-time error messages or poor or less than optimal system performance.
To access these configuration settings, from the server computer's Start menu select:
Advantage Database Server
ADS Configuration Utility
Click on the Configuration Utility tab button.
Number of Connections
Assuming a 25 user site, calculating this number as 3 times the number of users who will be accessing the software simultaneously. E.g.,
25 x 3 = 75
Number of Work Areas
Assuming a 25 user site, calculate this as 60 times the number of users who will be accessing the software simultaneously. E.g.,
25 x 60 = 1500
Number of Tables
The recommended setting is 120 times the number of companies the business operates. If the company accesses 3 different companies, then the calculation would be:
120 x 3 = 360
Number of Index Files
The recommended setting is 150 times the number of companies the business operates. If the company accesses 3 different companies, then the calculation would be:
150 x 3 = 450
Number of Data Locks
The recommended setting is 40000.
It should also be noted that if the "Worker Thread" count "Configured" reaches "Current" then under the Configuration Utility tab, Misc Settings, the "Number of Worker Threads" should be increased by one, to allow for better response times for individual users.
The above setting should be reviewed 7, 30 and 60 days after installation or when significant changes to user access to the database occurs. Settings may be increased or decreased based on actual usage, which is reported under the Max Used column on the console. Plenty of safety margin should always be added to ensure that client applications do not experience errors when accessing the database.