SSRS Performance
SQL Server Reporting Services, SQL Server stored procedures, SSRS, SSRS Performance, Stored Procedures
I Have created an SSRS Report for retrieving 55000 records using a Stored Procedure.When Executing from SP it is taking just 3 Seconds but when executing from SSRS report It is taking more than one Minuits.How i can solve this problem?
Software/Hardware used:
Software/Hardware used:
ASKED:
December 4, 2008 12:05 PM
UPDATED:
December 20, 2008 3:02 AM
Answer Wiki:
Hello.
Some one tell me assign a input parameter to a local variable of de same type of begin of the Storeprocedure and it to use once time input parameter and multiple times of local variable. This working well to me.
CREATE PROCEDURE DoItFast
@parameter1 datetime,
@parameter2 char(20)
......
DECLARE @INTERNAL_DATE AS DATETIME;
DECLARE @INTERNAL_NAME AS char(20);
SET @INTERNAL_DATE = @parameter1;
SET @INTERNAL_NAME = @parameter2;
---USE MULTIPLE TIMES @INTERNAL_DATE and @INTERNAL_NAME
I hope to help you.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
