Home » Developer & Programmer » Reports & Discoverer » Reports Performance
Reports Performance [message #252892] Fri, 20 July 2007 08:53 Go to next message
ora_dev
Messages: 27
Registered: December 2006
Junior Member
I am running reports 6i.

I run a query with a UNION in pl/sql developer and the queries executes within a minute. I cut and paste the same query into reports and it takes over 10 minutes. Fiddled with the order by fields and still no improvement.

Thanks

Report message to a moderator

Re: Reports Performance [message #252894 is a reply to message #252892] Fri, 20 July 2007 09:05 Go to previous messageGo to next message
diku
Messages: 23
Registered: April 2007
Junior Member
Check out which part of the execution is holding up your report.

It might not be your SQL Code but conditional formatting in Reports which you do. Are you fetching data from remote servers? That could also slow the execution.

Report message to a moderator

Re: Reports Performance [message #252899 is a reply to message #252894] Fri, 20 July 2007 09:43 Go to previous messageGo to next message
ora_dev
Messages: 27
Registered: December 2006
Junior Member
No remote servers and no conditional formatting with triggers.

However I noticed if the report is in tabular format it runs in under 5 min but as soon as I change it to a multiple break report it impacts on the performance.

Report message to a moderator

Re: Reports Performance [message #253509 is a reply to message #252899] Tue, 24 July 2007 02:46 Go to previous message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member
Open your report in report builder
TOOLS----->Trace
specify here trace file and trace mode
Also check trace options according to your report
You will come to know each module in report getting how much time..
Then u can tune your report easily i think...

Report message to a moderator

Previous Topic: Create Report in Chinese
Next Topic: order by in 5 queries report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 07:15:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.