Database Design

Questions on connection pooling and concurrent transactions

Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2008

Posts: 1

Reputation: iranichai is an unknown quantity at this point

Solved Threads: 0

iranichai

Offline

Newbie Poster

Questions on connection pooling and concurrent transactions

Dec 12th, 2008

Hi,

I have a transaction with , lets say, 5 INSERT/UPDATE statements with some SELECT statements in between. I am using one connection for all the update/insert statements and another connection for SELECT statements from connection pool. Is there any problem doing do? Should I use the connection intended for UPDATE/INSERT statements for SELECT statements also?

Thanks,
IC