Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Slow Stored Procedures

Status
Not open for further replies.
GShort

GShort

MIS
Apr 20, 2005
70
0
0
US
We have a Stored Procedure that when ran in the SQL Server Management Studi takes about two seconds to run. But when I place the Stored Procedure in a report to run it takes roughly two to five minutes.

I am a quite perplexed by this problem, any suggestions?

 
Sort by date Sort by votes
Have you got a lot of formatting in the Report, i.e. highlighting, alternating font colours, formulae, graphics, charts etc..

All these are factors as to how quickly the report will run, even though the data may be being returned quickly, if there is a lot of report rendering too then this will slow down the report.

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! :eek:)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ghbeers
  • Locked
  • Question
I'm creating a stored procedure. I 2
Replies
4
Views
55
ghbeers
ghbeers
Luvsql
  • Locked
  • Question
No fields listed for any stored procedure chosen
Replies
0
Views
28
Luvsql
Luvsql
hneal98
  • Locked
  • Question
Calling an Oracle Stored Procedure from Report Services...
Replies
2
Views
33
hneal98
hneal98
swenri
  • Locked
  • Question
How to display dates used in stored procedure in crystal report ?
Replies
1
Views
22
SQLScholar
SQLScholar
spiego
  • Locked
  • Question
Parameters and Stored Procedures
Replies
1
Views
22
xlbo
xlbo

Part and Inventory Search

Sponsor

Back
Top