BusinessObjects Board

Running Bo Report - performance

Hai…

My report usually takes more than 15 mintues to run… i am using bo5i

please i need more tech help


stalint (BOB member since 2004-12-14)

Can you give a little more detail? How many rows are returned by the query? Is it using complex conditions. Is it using any conditions at all?


irish_stan :ireland: (BOB member since 2003-05-13)

Can you measure the time that DB engine takes to execute data provider’s query?


shamit (BOB member since 2004-07-01)

I have couple of questions:

(1) r u using FC or webi?

(2) How many users using this report?

(3) What kind of Database u r using?

Also u can try like that:

If u see ur DB engine taking less time ( significantly) then u have to check universe.Check— Do u have any unwanted join between the tables? Do u have lots of alias tables? etc

Also copy ur SQL statement and instead of putting it into ur Database engine use this for free hand SQL and see how long it it taking to get the data.

plz let me knowif u get something interesting.

—chan2005


chan2005 (BOB member since 2005-05-29)

Please, take some time to familiarize yourself with the FAQ (Frequently Asked Questions). You will find this relevant topic here.


Andreas :de: (BOB member since 2002-06-20)