system
April 20, 2010, 10:08am
#1
Hi Friends,
what are the better ways to increase the performance of the Universe as well as reports.
Regards,
eswar519 (BOB member since 2009-05-26)
MarkP
April 20, 2010, 10:59am
#2
eswar, many of your recent topics can be found by searching. Some are stickies at the top of each section. Please use the SEARCH FUNCTIONALITY within the board in future.
Thanks,
system
April 20, 2010, 11:02am
#3
If you had used the search feature on the homepage of BOB (top right), this post would not have been required at all
Hi,
Plz. Can anybody tell me what all are the performance tuning techniques can be implemented in a universe and a report. Though I ddin’t face any performnace issue till now but just wanted to know the techniques available.
Many Thanks
Praveen
kk@bi (BOB member since 2009-06-16)
Hi all,
I have performance issue in executing a query and returning the result set. While executing the query in toad, i get first 500 rows within 10 seconds. But to return the entire result set it takes minutes together.
Now, Is there an option to make BO to fetch these first 500 rows and display them in the report, than waiting for the entire result set instead?
I have tried changing the array fetch size to 500 and array bind size (to 1000) in universe (not sure if this is the right approac…
haider (BOB member since 2005-07-18)
(BOB member since 2005-07-18)