Hi All,
I have developed a report into cognos 10.2. I have used SP because of functionality complexity . When i exceute my Proc within MS SQL SERVER then it will take approx 1 Min..
Report is using same proc multiple times with different filters but it's takes approx 15-20 Mins to run Please check attached xml code for same and suggest improvements trips
Thanks in advance.
Regards,
Deepak
Quote from: deepak.seth@Steria.co.in on 03 Feb 2015 07:16:59 AM
Hi All,
I have developed a report into cognos 10.2. I have used SP because of functionality complexity . When i exceute my Proc within MS SQL SERVER then it will take approx 1 Min..
Report is using same proc multiple times with different filters but it's takes approx 15-20 Mins to run Please check attached xml code for same and suggest improvements trips
Thanks in advance.
Regards,
Deepak
It looks to me like you are calling the SP multiple times to populate multiple queries. The SP may take around a minute to run once, but it's obviously going to take around 15 minutes to run 15 times with different parameters passed to it.
I'd humbly suggest your design ethos for the report is at fault here.
MF.