darrgyas
asked on
Database connection pooling
Hi all,
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 = 192.182.162.2; Protocol = TCPIP; Port = 50000; Uid = db; Pwd = pwd"
Any help is appreciated
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 = 192.182.162.2; Protocol = TCPIP; Port = 50000; Uid = db; Pwd = pwd"
Any help is appreciated
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.