Re: Parallel Connections
- From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 21 Dec 2005 13:49:58 -0000
Hatim wrote on Mon, 19 Dec 2005 03:49:02 -0800:
> Hi All,
> I am using VB6 & ADO 2.5 to get data from SQL Server.
> There are some queries that I run daily on our servers(using connections
> and recordsets in a single form in a VB project).
> A lot of these queries take a time(more than one minute).
> So,my problem here is that I wait all the queries to be executed
> separately (One by One).
> My question is:
> Are there a way to run many queries on many servers parallel at the same
> time on the same VB form.
I guess you could use one ADO object per query, and run them in Asychronous
mode. You can then loop to check the state of each object to determine when
they have completed running, and close down your app when they're all
finished. However, you'll have to take care of handling any deadlocks or
conflicts that occur, which could get messy.
Dan
.
- Prev by Date: Re: How to automaticly retrieve a new record(new line)
- Next by Date: Re: Parallel Connections
- Previous by thread: Re: Parallel Connections
- Next by thread: Re: Parallel Connections
- Index(es):
Relevant Pages
|
|
