SDAC Connection Pooling with TWebModule in Linux environment
We
are trying to evaluate whether we can, and exactly how, we can use connection pooling with TWebModule in a Linux env (Apache specifically).
We have essentially stripped all threading from our application as it does not seem to play well under Linux.
As we understand it, each request to TWebModule spawns a new thread, and we create an instance of TmsConnection within that request (thread).
So, how can we share a connection pool in this scenario? Can we create the pool and pass it into each request to be assigned to the connection?
Any help or advice will be much appreciated.
Delphi 11.x