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

Report message to a moderator

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: 68763
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: WITH clause in Report Builder
Next Topic: Case Statement In Oracle Reports Query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 22 10:51:00 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.