[closed]Report executing too Slow

[BIsrik]

Hi,

I have a report in which i drag six columns from two tables. 3 columns from Table A and 3 columns from Table B. The sql generated is also fine...( The report doesn't have any filters too)

But when i execute the report in HTML the first page comes quick but when i press the bottom the report executes and executes and never stops. If i execute in PDF the report server hangs off...

When checked the total rows for that combination it came around 100 thousand. I am not getting the point the same sql executes quicker in TOAD but why is it taking a hell lot of time in RN.

Have even the reportnet on ISAPI and have set the auto summarization of TM to 'NO'.

Srik

[cognosfreelancer]

Srik

I can think of 2 things:

1) Check the properties of the tabular model of the affected SQL statement in ReportNet. Make sure the property 'Autogroup and Summarize' is set to No. ReportNet defaults this value to 'Yes' leading to the addition of Select distinct clause to the SQL statement and performance problems.

2) More likely, based on your post, check whether the SQL statement is really running quickly in TOAD. Generally only the first 50 or so number of rows get retrieved creating an impression that the SQL statement is quick. Force TOAD to retrieve all rows by doing a row count operation on the result set. You may be surprised at what you discover.

It would be nice if you could get back either way with your findings...

NKT

[sir_jeroen]

What's the status of this topic?

[BIsrik]

i have set the auto grouping to No and even checked the total records in toad. It gave the results in few seconds...

Srik