Performance issue

[Cognos8]

Hi ,

Normally the report runs  within 40 seconds. but i have used the render variable ( 60 ) . to hide and display the list , prompt ... normally will it affect performance ?

[uttam.mistry]

once, i have asked this to cognos consultant, and he said.. it should not affect much..

let me know your findings!!

[CognosPaul]

SQL is usually not generated for non-rendered objects. If the list is a major bottleneck, using a render variable should improve performance significantly. An easy way to confirm would be to either examine the audit logs, or run a trace as the report is running.