Can Business Objects run faster 2

[scottian]

just a quick question. Is there a way to make business objects run faster.

At present ive got a querie running that takes a list of reference numbers and queries a data warehouse to return a post code. Thats all its doing, two fields. but its over 8 hours to complete.

Is there anything i can do?

"My God! It's full of stars...

 

[BrianTyler]

Basically, this is not normally a BO problem, but a database problem.

Try with just one reference number. This could give an indication as to whether a table scan is being used.

How are you getting the list of reference numbers in? Are the appropriate indexes set up on the database? Depending on the database, are the required optimisation objects up to date (eg runstats for DB2)

I suggest you look at the generated SQL to ensure that BO is being sensible. Use the DB tools to generate esimates/access plans - if you are not technical enough your DBA could help.

Good luck

Brian

 

[angoid]

I'd concur that this is unlikely to be a BusinessObjects issue per se.

Check the SQL as suggested .... and check the universe to see how the SQL is being built.

Pointers: If you have an outer join to a view that joins large tables, this can cause slowness.

Typically, I yank out the raw SQL and run it through a PL/SQL Developer or SQL*Plus session (we use Oracle) and then look at the SQL with a view to tuning it for more optimal performance. Then go back and make any necessary changes to the report / universe as required. Clearly, if changing the universe, you need to ensure you don't break anything else relying on that bit!