Skip to Content
0
Nov 07, 2012 at 10:42 AM

When date range gets too large, report runs forever

198 Views

Hi experts

Our client reported a problem with one of our reports. After testing it seems when the date range becomes too big, the report just can't process the information.

I've done countless searches on ways to improve performance both in BO and in database. Array fetch size in universe etc, indexing, aggregation

However, I don't understand this 'point of critical mass' where the report stops running and I can't find any related posts.

I'd love a top 10 things to do to improve performance!

Any advice welcomed.

Regards

Eddie