Need to improve performance of the Report excecution.

[devardekartb]

Hello Guys,

I am working on a requirement where we have imported 3 procedures and All the three procedures are combined in a single page as per business requirement.
The second and third procedure share a master detail relationship with the first procedure.The report currently taking 8 hours to execute.The master detaill relationship is based on Exception ID which is used to section the report.What are the ways to improve the performance? I tried PDF and EXCEL formats. The report output is attached below for your reference.

[BigChris]

Not related to your problem...but is that screenshot ok to share with the world?

[MFGF]

Hello Guys,

I am working on a requirement where we have imported 3 procedures and All the three procedures are combined in a single page as per business requirement.
The second and third procedure share a master detail relationship with the first procedure.The report currently taking 8 hours to execute.The master detaill relationship is based on Exception ID which is used to section the report.What are the ways to improve the performance? I tried PDF and EXCEL formats. The report output is attached below for your reference.

I'm trying very hard to see any possible justification you could think of for posting a confidential document like this on a public forum page. This constitutes what appears to be a serious security breach on behalf of your employer or client. I have removed the attachment after two logged views - Big Chris and myself. If this hadn't been spotted, your employer could have been severely compromised, and it's only due to Big Chris's diligence that it was spotted so soon.

Please read the Forum Etiquette post below, paying close attention to point 6:

http://www.cognoise.com/index.php/topic,24030.0.html

MF.

[navissar]

It is near impossible to improve the performance of a master detail relationship based on procedures. I would break the procedures down to the SQL, model them in a framework manager DQM package, and base the report on that. If that's not possible, maybe apply a mini-ETL process where your procedures write to a table periodically and you read from that table.