Single database connection, multiple statements executing in parallel?

Single database connection, multiple statements executing in parallel?

Post by vprabh » Sun, 21 Sep 2003 02:09:58


Hi,

A single database connection handle is initially created, later
multiple threads use this connection handle to execute different sql
statements in parallel.

Similarly a single environment handle is created and mutiple database
connection handles are thn created.

Could you please tell me any problems (performance, etc.) with these
approaches.

Thanks,
Vishal
 
 
 

Single database connection, multiple statements executing in parallel?

Post by Vishal » Sun, 21 Sep 2003 06:00:56

Thank you for your response. I hope there are no problems in creating multiple database connection handles for a single environment handle.

**********************************************************************
Sent via Fuzzy Software @ http://www.yqcomputer.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

 
 
 

Single database connection, multiple statements executing in parallel?

Post by Brannon Jo » Sun, 21 Sep 2003 06:21:34

There are no problems in creating multiple connections per environment.



multiple database connection handles for a single environment handle.
ASP.NET resources...