Stored procedure taking more time in execution

Question

0.00/5 (No votes)

See more:

I have a stored procedure that is taking more time for execution when I am calling the same sp from C#.Net code.

I observed that whenever I am executing the same stored procedure from Microsoft SQL Server Management Studio, it's working fine.

I have no idea why this thing is happening?

Any help will be highly appreciated...

Thanks in advance!

Posted 7-Feb-12 22:31pm

jai000

Add a Solution

Comments

zyck 8-Feb-12 4:37am

can you post your Stored Procedure, if possible?
how many data or records do you retrieve when you execute your sp?

Sergey Alexandrovich Kryukov 8-Feb-12 4:40am

How do you know you time it correctly? Most likely, the problem is there...
--SA

OriginalGriff 8-Feb-12 4:41am

We would need to see the stored procedure, and the code you use to call it.
Some idea of the time difference would help too - are me talking millseconds? Minutes? Hours?
Use the "Improve question" widget to edit your question and provide better information.

1 solution

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)

RDBurmon · Answer 1 · 2012-02-08T00:33:00

Below could be the issue because I had the same issue :

My assumption is as below with respect to your SP :
1) Stored procedure one or more column in return type which has data more than 10K characters
2)your sql server box and .Net framework box is different.

Root cause if above assumption is true.
When you run stored procedure from C# it will execute in seconds (may be) but take more time to transfer data from sql server box to framework box.

Solutions
If your are using this stored procedure to generate report then try to use SSRS report instead of .net data report

Since your question not state much details above could be your analysis point

Hope this helps if yes then accept and vote the answer otherwise revert back with your queries

--Rahul D.