🚀 go-pugleaf

We have a product consisting of several hundered seperate applications, all 
of which access an Oracle database.
The main program is not much more than a simple menu that spawns all of the 
other programs.

The problem is that on some of our larger customers, they may have 50 or 
more people each running an average of 10 or so programs at a time from the 
menu.

Each program has a database connection, and up to 30 query components. 
Since this creates a seperate database connection for each program, some of 
our clients are starting to experience some serious performance issues on 
the database because of all the open Oracle connections.

Is there any way the main application can open a single connection to the 
database, and the spawned programs share that database connection component?

Datasnap kind-of allows us to do this with datasets, but it requires all of 
the datasets to reside on the application server.  In our case each program 
does something entirely different with the data, so putting all the datasets 
in an application server really won't work well for us.  Also, our product 
consists of literally hundreds of executable programs executing thousands of 
different queries on around 100 tables, it would be a nightmare to try to 
put all the necessary datasets in a single application server.

We really need to share the database connection, but have the datasets 
themselves in the individual executable programs.


Thanks for any ideas here.

Lance Robaldo
Lance@Robaldo.com