Webi Report Performance

[system]

Hi Friends,

I need a Help from anyone.
I developed a Report which has 13 Data providers, In order to Refresh this Report BO is Taking almost 10 to 15mins approximately. Which is not Considerable.

I Guess this is due to the more no. of Data providers. How many data providers we have those many times BO need to hit the Database, This will impact the report performance.

But my Problem here is i tried to Reduce the no.of Data providers unfortunately i couldn’t.

Can anyone help me how to improve the performance in order to reduce the Refresh time.

Any advice is very help full to me friends. at least to give a light to proceed.

---

anukruthik (BOB member since 2011-01-11)

[system]

Hi,

Check this sticky topic as the starter:

Webi & Better Performance

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)

[system]

Hi ,

Thanks for your help.

i tried by changing the server properties but there is no use, can you please let me know which doc should i check in order to rectify this problem.

---

anukruthik (BOB member since 2011-01-11)

[system]

See also Why is my report so slow, an oldie but goldie 8)

---

Andreas (BOB member since 2002-06-20)