How can I execute different methods at the same time?

Question

0.00/5 (No votes)

See more:

Hi All,

In my application I am using a dataset and 4 methods like below.

Dataset ds=new Dataset();
ds=businesslogiclayerObject.method1(a,b,c,d);
ds=businesslogiclayerObject.method2(a,b,c,d,e);
ds=businesslogiclayerObject.method3(a,b,c,d,e,f);
ds=businesslogiclayerObject.method4(a,b,c,d,e,f,g,h);

Businee logic layer:

public Dataset method1(int a,string b...string d);
{
//used hash table object  to send parameternames and storedprocedure to DataAccess Layer.

}

same syntax for remaining 3 methods also.

(a,b,c,d,e,f,g,h) are the parameters to Stored Procedure in Businesslogic Layer. Till now I did not implement any threading concept so they are executing one by one.This takes lot of time to get result set in Dataset.

How can I execute above 4 methods at the same time?

Help me.

Regards,
N.SRIRAM

Posted 26-Jan-11 23:43pm

SRIRAM 2

Updated 26-Jan-11 23:46pm

m@dhu

v2

Add a Solution

Comments

m@dhu 27-Jan-11 5:46am

Edited for code block

Sandeep Mewara 27-Jan-11 5:49am

Instead of calling 4 methods, I would suggest you to handle it in SP at once!

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2011-01-26T23:52:00

Remember that your code is ASP.NET, so once your page finishes rendering, it will return to the user and it will not wait for your other threads to finish. As someone else said, you can make them one SP to cut time, you can also look to speed up your SQL if it's inefficient, improve your DB design if that's the issue, or if you don't care if the page goes back before the work is done, farm this work off to a service that does it without slowing your pages down.

Yusuf · Answer 2 · 2011-01-27T00:39:00

In addition to what others said:

It appears that you are building using the same parameters.

ASM

ds=businesslogiclayerObject.method1(a,b,c,d);
ds=businesslogiclayerObject.method2(a,b,c,d,e);
ds=businesslogiclayerObject.method3(a,b,c,d,e,f);
ds=businesslogiclayerObject.method4(a,b,c,d,e,f,g,h);

your parameter is growing from a,b,c,d to a,b,c,d,e,f,g,h. well the first is a subset of the last. It is very hard to tell with out looking at the code, but do you have repreatitive code on all the methods? Can you re-factore the code, such that, fewer methods can do the work for you? may be all what you need is the last method and then refactor the work? But again very hard to tell without seeing the code.

soni uma · Answer 3 · 2011-01-27T00:01:00

Solution 2

You can use DataReader instead of DataSet.

Posted 27-Jan-11 0:01am

soni uma

How can I execute different methods at the same time?

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0