Running more then one Functions at once, HOW?

14 Aug 2010 3:20 AM

Spero

I have a VB project that open up a NYSE table (ADO) of all the
symbols, feeds them into a web services where I take the xml response
and writes the quotes and volumes to server. The problem is that I
have to wait for all the NYSE symbols to run to the last record before
it moves to the next table exchange and get those quotes and writes
the trading values. I guess my question is how can I open up several
datasets to get the trading symbols I need and run them all at the
same time instead of having to wait for one table to move to EOF? Am I
looking for something like backgroundworker, hyperthread? Basically
how can you run multiable functions at the same time?

14 Aug 2010 10:35 AM

Jason Keats

Spero wrote:

> I have a VB project that open up a NYSE table (ADO) of all the
> symbols, feeds them into a web services where I take the xml response
> and writes the quotes and volumes to server. The problem is that I
> have to wait for all the NYSE symbols to run to the last record before
> it moves to the next table exchange and get those quotes and writes
> the trading values. I guess my question is how can I open up several
> datasets to get the trading symbols I need and run them all at the
> same time instead of having to wait for one table to move to EOF? Am I
> looking for something like backgroundworker, hyperthread? Basically
> how can you run multiable functions at the same time?

This isn't a VB.NET group, but I'll give you some free advice anyway -
use Retlang: http://code.google.com/p/retlang/

14 Aug 2010 2:30 PM

Nobody

This group is for VB6 and earlier(VB Classic). VB.Net and all dotnet groups
have either "dotnet" or "vsnet" in the group name. Please use the following
group instead:

news://news.aioe.org/microsoft.public.dotnet.languages.vb

14 Aug 2010 5:36 PM

Cor

This question does not mater what program language is used. It is about
design.

The way the data goes over the line does not speed up by whatever
improvement on the client side.
Take a look what is your smallest gap in the data pipeline, in that part you
have to go for improvements, not is things as backgroundworkers or whatever,
it will really not speed up your process as it still is waiting for the data
go get. There is not any computer that is not fast enough to accept any
data on a whatever port in a single thread.

To make it more clear with a sample, If your data handling method takes 10
milliseconds while your data transfer takes 10 seconds, then splitting the
process of data handling can maybe be improved to 7 milliseconds (this does
not go linear). What did you gain?

By the way what program languages are you using Ado is VB6 while datasets
are AdoNet which is a Net feature.

Cor

Show quoteHide quote

"Spero" <robsp***@gmail.com> wrote in message
news:58544bbd-faa6-4ec8-9543-a8959489f4e1@l20g2000yqm.googlegroups.com...
> I have a VB project that open up a NYSE table (ADO) of all the
> symbols, feeds them into a web services where I take the xml response
> and writes the quotes and volumes to server. The problem is that I
> have to wait for all the NYSE symbols to run to the last record before
> it moves to the next table exchange and get those quotes and writes
> the trading values. I guess my question is how can I open up several
> datasets to get the trading symbols I need and run them all at the
> same time instead of having to wait for one table to move to EOF? Am I
> looking for something like backgroundworker, hyperthread? Basically
> how can you run multiable functions at the same time?

16 Aug 2010 2:36 PM

Paul Clement

On Fri, 13 Aug 2010 20:20:17 -0700 (PDT), Spero <robsp***@gmail.com> wrote:

¤ I have a VB project that open up a NYSE table (ADO) of all the
¤ symbols, feeds them into a web services where I take the xml response
¤ and writes the quotes and volumes to server. The problem is that I
¤ have to wait for all the NYSE symbols to run to the last record before
¤ it moves to the next table exchange and get those quotes and writes
¤ the trading values. I guess my question is how can I open up several
¤ datasets to get the trading symbols I need and run them all at the
¤ same time instead of having to wait for one table to move to EOF? Am I
¤ looking for something like backgroundworker, hyperthread? Basically
¤ how can you run multiable functions at the same time?

If this is for VB 6.0 you might be hard-pressed to accomplish this task. If it's for Visual Basic
..NET then you may want to post your question at the below link:

http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/threads

Paul
~~~~
Microsoft MVP (Visual Basic)