From the ADS helpfile:
The CONNECTIONS, WORKAREAS, TABLES, INDEXES, and LOCKS configuration parameters control the initial amount of resources Advantage will allocate at startup. Should Advantage run out of available connections, tables, etc., it will allocate more resources to accommodate more open connections, tables, etc. Later, if those extra resources are not being used, Advantage will free them and reduce the number of available connections, tables, etc.
QUESTION: What happens when more resources are needed in terms of the upcoming database request while ADS is increasing the parameters, so does the application have to wait until ADS has finished the allocation?
ANSWER: Yes the request will need to wait for more resources to be allocated. If any delay is unacceptable, the customer should set the configuration parameters to approximately the values used by the server. Any easy way to determine these maximum values is with ads_cfg.exe. No extra allocations should be needed then.
