Here is my question below.
Always make a connection or disconnection for every
I assume that your architecture is n-tier, something like:
DB_SERVER <---> APPLICATION <----> MANY_CLIENTS
...and you consider a solution in the APPLICATION part?
Assuming so, it still depends:
So you have to consider the gain and the cost... the result depends heavily on both the above factors.
Of course, you can also hit some connection-table size limit if you consider really many concurrent connections. Or you may have some securitiy-specific connection limitation between
APPLICATION. In such cases multiplexing client connection into one may be the only option.