We have a SOAP service in ROSDK. Each session creates a connection to a database, runs queries, and returns the results. There is a built-in delay, therefore, on every request as the database connection is established.
How can I create a “session pool” or “database connection pool” in order to have already-established connections that can be reused for each new request? The solution, of course, has to take into account whether all pooled connections are in use when a new session is started, and either expand the connection pool or wait.
It appears this is available in Data Abstract, but we are using ROSDK.