Database connection pooling
Posted on 2013-01-25
I have an application that needs to process dozens of incoming messages a second.
Each message needs to be analyzed, which requires several reads/writes to a DB2 database.
For each message that I receive, I create a thread, create and open a database connection,
do the processing and close the connection.
How can I manage the connection(s) to the database more efficiently?
Here's my connection string (just in case):
"Provider=IBMDADB2; Database = db; Hostname = 126.96.36.199; Protocol = TCPIP; Port = 50000; Uid = db; Pwd = pwd"
Any help is appreciated