Process pooling is available in the following three modes:
Built-in pooling
AppServer pooling
Disabled pooling
Using built-in pooling, OpenEdge Management handles a set of OpenEdge client processes. When the ABL APIs are called, these processes improve performance by eliminating the overhead of starting and stopping a process each time. You can control the maximum number of _progress processes that are kept alive at any time. The processes do not maintain a persistent connection to the database. Instead, each request to OpenEdge Management or OpenEdge Explorer from a Web browser causes one of the AVMs (_progress.exe) to connect to a database and then run the proper data administration API. Built-in pooling is the default process pooling mode.
Using AppServer pooling, it is the AppServer, instead of the OpenEdge client process, that runs the ABL APIs. Each request from OpenEdge Management or OpenEdge Explorer is sent through the specified AppServer using a specified AppServer URL to call the ABL API. The Java Open Client is used to connect to the specified AppServer.
You can set up AppServer pooling to manage the calls to the database by using the AppServer instead of through an_progress AVM managed by OpenEdge Management. You control the number of agents with the AppServer settings.
Note: The AppServer for pooling must be dedicated to OpenEdge Management (in other words, the AppServer must not be in use by other ABL clients), and it should be configured to use the state-reset mode. In addition, there must be no database connections defined for the agents.
When you disable pooling, you use the least amount of memory. However, you also experience the least effective performance. A new AVM is started on each request from the Database Administration Console. A new database connection is made on the startup of each OpenEdge client process (_progress), and the ABL API is run using the -p startup parameter.
You can disable pooling in the following cases:
If you experience issues using either built-in or AppServer pooling
If you prefer not to have _progress running continuously