I am working Business Objects 6.5. My BO Report is fetching the data from 3 tables. Those are Ida_Error_Record,Operator,Network_Node. Ida_error_Record table is having more than 50 million records. So my BO Report is taking 60 min to refresh the data. Can we apply performace tuning at BO level to retrieve the data in less time. I kept this report for scheduling on daily basis. Because of this huge time the job in BCA is getting failed. Any suggesions?
There is nothing much (esp. in your case where the report time 60 mins.) that you can do at BO level to improve the performance or tune the report.
You need to check the performance of the queries built by your DPs in the back end. If needed tune these queries by various ways (indexing etc.)
Have you searched before posting, there lots of threads on the same topic which might have given you some idea. Here are few to proceed with:
We are having the same problem but we have nothing to do on this issue as we have central repository. we often get table log problem too. it means if another user is retriving data from that table then we have to wait until he is done with that table otherwise we get “no more spool space” error. so now a days all i am doing is refresh two reports and go home.