Performance difference in rendering report html

[Blacksails]

Hi, i have a strange situation.my report queries run very fast on db but when i run report it is very slow.i notice a bif difference in rendering in html.i have simple list report.why?how could i improve rendering performance?where and which configuration settings should i set? it is true that setting fixed column size for list improve cognos rendering performance?thanks...

[Francis aka khayman]

are you sure it is in rendering of HTML? you said you have a simple list; are there nothing else in the report except the list? because this is the first thing I'll want to know...

... if you use the same query, in a basic report (nothing but list), and run using HTML output, is it still running very slow?

[Blacksails]

hi khayman.thanks for your i terest.yes, it is a simple list report with header and footer elements.one query.the query on netezza is very fast for the tables  that are involved.facts and dimension with million rows.netezza executes thr list query in 70sec and return with filter selected about 45000 rows.the list hase about 15 columns..but it is very slow to render.why?how does cognos function in the behind scenes?i ve read that i
cognos uses cursors for the result set that is stored on  a temp folder ...it s this the cause of slowness?or a bad report service configuration?