Problem with synchronous transactions 
Author Message
 Problem with synchronous transactions

Greetings,

I am looking for some insight into the "guts" of ADO here.
We have an application using ADO to "talk" to a MSSQL 2000 server.
Each thread of the application opens its own connection to the
same database and executes commands in synch. Even though the commands
affect different records in the database, we are still experiencing
a sequential response. In another scenario, we have two
threads which try to open a connection to two different databases in
two
different machines. Again, the response is sequential.

Any way to improve ADO's behavior?? Is this as good as it gets??

Cheers
CD



Tue, 04 May 2004 10:00:29 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. sqlplus -- synchronous/asynchronous problem

2. Tricky transaction problem: Catching EDatabaseError from one of several Post within a transaction

3. making bound recordset synchronous

4. Using CURSOR synchronous/asynchronous

5. Is it really synchronous?

6. Starting Synchronous 'Child' Jobs within SQLServerAgent

7. Is it really synchronous?

8. Synchronous job exection and sqlmail

9. Synchronous execution in VB...

10. calls to stored procs: synchronous or asynchronous?

11. Synchronous LISTEN/NOTIFY?

12. Asynchronous Vs. Synchronous


 
Powered by phpBB® Forum Software