BeginTrans & Connection Pooling under heavy load in VB 6

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gbStorm - 21 Apr 2005 21:06 GMT

I want to use ADO Connection transactions from a VB 6 Middle-Tier to SQL
Server 2000, but I don't understand how transactions are managed relative to
connection pooling.

I have 4 Web server boxes hitting the VB Middle-tier via COM+/DCOM on a
single app server box. I open/close the connection in each method that hits
the DB. I'll have 2 or three DB hits per transaction.

What is going to happen when I get 100-300 simultaneous requests on the same
Middle-Tier method? I am worried about one transaction blocking all the
others, or a single connection nesting transactions too deep.

Reply to this Message

JPM - 27 Apr 2005 14:26 GMT

I haven't dealt with this scenario in awhile but I know it used to be MTS
could be set up on a server to handle connection pooling. I'm a bit out of
the loop on the current equivalent but there must be something similar or
better that could do connection pooling for you.

Jim M.

> I want to use ADO Connection transactions from a VB 6 Middle-Tier to SQL
> Server 2000, but I don't understand how transactions are managed relative to
[quoted text clipped - 7 lines]
> Middle-Tier method? I am worried about one transaction blocking all the
> others, or a single connection nesting transactions too deep.

Reply to this Message

VB Forum / Database Access / April 2005

BeginTrans & Connection Pooling under heavy load in VB 6