Home » Developer & Programmer » Reports & Discoverer » Improving Report Server Performance (Oracle 10g)
Improving Report Server Performance [message #586955] Tue, 11 June 2013 18:53 Go to next message
mitumix
Messages: 2
Registered: June 2013
Location: Fiji
Junior Member

Hi Guys,

After exhausting searching on google and posting, I need some fresh ideas on this.

I currently have Report Builder 10g and it takes approx 40 seconds to generate 4000 page pdf.(not the preview one option, the Generate to PDF)
While the Report Server (Version 10.1.2.0.2) its taking approx 2 minutes for same report.

What is the typical time to generate a pdf report of lets say 4000 pages???
What are the ways i can improve this ?
What are the alternatives which are faster ?

Query :
Cost 117
Bytes : 75
Cardinaltity : 1

Running in Toad with paramters and scrolling to last row - few seconds.

Report : removing the fields and replaced them with tags &<>

report Server :
engine id : rwEng
InitEngine : 2
maxEngine : 8
minENgine : 2
englife : 50
maxIdle :30
cahce : 512
Re: Improving Report Server Performance [message #586958 is a reply to message #586955] Wed, 12 June 2013 00:00 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A 4000 pages report is completely useless, no one will read it.
So the fastest way to generate it is... to not generate it.

Regards
Michel
Re: Improving Report Server Performance [message #587164 is a reply to message #586958] Wed, 12 June 2013 16:33 Go to previous message
mitumix
Messages: 2
Registered: June 2013
Location: Fiji
Junior Member

Hi

Its a 4000 mail merge document/pdf.
Report is referring to the rdf,rep.
Previous Topic: WITH clause in Report Builder
Next Topic: Case Statement In Oracle Reports Query
Goto Forum:
  


Current Time: Tue Sep 16 12:51:47 CDT 2014

Total time taken to generate the page: 0.12197 seconds