system
December 29, 2010, 6:00am
#1
Hi
I have 100 s of report in production environment.out of 100 only some reports are taking more time to featch data.can any body helpme the root cause.But those reports which is slow using the report objects can be used by other reports are running fine.
I check all joins it is fine and tables having indexes
kindly help me
send2upp (BOB member since 2010-12-16)
system
December 29, 2010, 8:48am
#2
Hi,
Check these 2 sticky topics if they would help you:
Why is my report so slow?
Submitted by kmahler, additional comments by Andreas (July 2009).
What makes up the total time a report runs from hitting the Refresh button to being displayed:
Query execution time (database side)
Transferring results across the network to the client/web browser (network bandwidth & latency)
Computing local report variables, formulas, local report filters, alerters, etc. within the report (BOE server/ DesktopIntelligence workstation)
Rendering the page (pag…
Below is from my notes.
Couple Questions:
what am I missing below?
“…Allocating table weights…”: how do I do that, and what are the benefits?
“.…Minimizing usage of derived tables….”: What are the benefits? I thought having derived tables has zero effect --apparently I’m wrong–
for XIR2 web.xml location is fine, for XIR3 there are more than one web.xml files exist, for timeout purposes which one to modify?
thanks
MrH
===========================================
::
:: Faster WEBI Reports :…
Marek Chladny (BOB member since 2003-11-27)