System Performance to handle large record sets

[Former Member]

One of the comment from user community was to understand the system Performance or mechanism to handle large record sets especially when Adhoc queries can potentially cause huge result sets.

What can we do for Business OBjects to hadle this..

Please share your suggestions.

Thanks,

Ven

[Former Member]

Yes this is a common issue. Definitly it will take time to execute a large number of data. But here is some condition like:

If you select a large number of data like "Select * from tbl" this will be fine. It will not take large amount of time. But if you want to get data by joining two or three or more tables with complex calculation and grouping then it will take time to execute. In that case a good universe design can play a vital role to enhance performance. You can also limit the number of rows if amount of return rows are huge.