Performance on conditional blocks.

[intrepid402]

Hi
Just a curious question. Which approach usually gives better performance in displaying data? Conditional Blocks or to display data based on 'Render variable' in properties?

Any previous experiences or thoughts will be much appreciated!

Thank you.

[cognostechie]

Render Variable. Reason -  It will only execute the query that is needed based on a certain condition returns true. Render Variables can also be used with different pages in the report.

[intrepid402]

Thanks Cognostechie,
That really helped. Also, Which would have a better performance? 5 lists on one single page or, 3 lists in one and 2 in another? i.e. Does adding pages affect the performance?


Thank you!

[cognostechie]

Pages will have no impact on performance. It's the number of queries that will have impact on performance. The idea behind a Render Variable is to stop queries from being executed that are not required based on a selection criteria.