Can anyone tell me why the processing time for a stored procedure report would be so excessive? If I execute the stored procedure in Query Analyzer, passing variables in, it processes in 1:40. When I create a stored procedure report in Cognos Impromptu, passing variables in, it processes in over 10 minutes! This is not acceptable, but I don't know how to get around the processing time. As a stored procedure report, it is automatically processing as database only. Any thoughts?
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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Processing time excessive for stored procedure report
- Thread starter amykrage
- Start date
Similar threads
- Locked
- Question