in stored procedure level iam getting the data n quickly

Question

0.00/5 (No votes)

See more:

I am getting an data from an stored procedure within 40 seconds but when i access the same data from application level and display it in report and also in window with radcontrols.it takes around 2 min to display what is the reason for it. could anyone help me out

Posted 25-Dec-11 19:47pm

ashok_89

Updated 27-Dec-11 17:46pm

Wonde Tadesse

v4

Add a Solution

4 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)

Mehdi Gholam · Answer 1 · 2011-12-25T19:55:00

Solution 1

Raw data access is obviously faster than transferring that data to a client and processing it for a report.

Your bottle neck is your report engine and your report viewer.

Posted 25-Dec-11 19:55pm

Mehdi Gholam

Comments

ashok_89 26-Dec-11 2:06am

iam using the crystal reports,any fine tuning should be done in that and how

Mehdi Gholam 26-Dec-11 3:00am

Optimizing Crystal Reports is specific to your report and subjective so unfortunately I cannot help you in that regard.

sriman.ch 27-Dec-11 22:59pm

I agree with Mehdi...It depends your requirements and how much data you are retreiving ....

Wonde Tadesse 27-Dec-11 23:46pm

5+

Mehdi Gholam 28-Dec-11 0:26am

Thanks

sriman.ch · Answer 2 · 2011-12-25T19:57:00

Solution 2

Hi,

There may be several reasons for this. Here are few

1. How you are retreiving and binding data.
2. The no of control and their respective weight.
3. The no of users accessing the same report at the same time.
4. What type of reporting tool you are using.
.......

Hope this helps.

Posted 25-Dec-11 19:57pm

sriman.ch

Comments

ashok_89 26-Dec-11 2:06am

iam using the crystal reports,any fine tuning should be done in that

sabbi26 · Answer 3 · 2011-12-25T20:10:00

Hi, Ashok

The Data retrieving from database is depends on data u have.
For execution of query it takes very less time in sql server where as if u are accessing the same data through the application it takes much time.
So use stored procedures to retrive the data. and write the querys which are having less joins. use temp tables etc.. to increase the application performance.

Thanks.,

Sarvesh Kumar Gupta · Answer 4 · 2011-12-27T17:44:00

Solution 4

IT depends on some points:

1. Sql Connection or LAN Connectivity
2. Some Major Code on Databound event if you are displaying data.

Check all these things.

Posted 27-Dec-11 17:44pm

Sarvesh Kumar Gupta