is ReportNet good?

[spicysudhi]

hi

its a question want to ask u all. i am doing somehting wrong or how it is "designed" to work!

two tables in Framework Manager, links defined (an outer join). tables contain around 100 thounsand and 500 thousand records each. In report, got a prompt page for filtering. and normal listing report.

this report takes nearly an hour to display timedout message!

If i run the same in Oracle's SQL session, i get results in a second! So its not the problem with database!

this kind of situation i found more when there is a join, if from a single table, its better than the worst.

wht u suggest to make it run keeping in mind that users cant wait for hours to get a report!

regards,
sudhi

 

[DoubleD]

Ensure that all your SQL is being processed on the database.
Depending on how you have your report written, Reportnet may be trying to do calculations, conversions, or formatting locally. If you're server isn't up to the task this could be a huge issue.

The most common performance problem I've found in Cognos against Oracle regards Date fields. Oracle only stores DateTime fields, sometimes Cognos will assume it has to bring all the data back and perform the Date filter locally.

It might help us if you could provide the SQL you expect to see running on the database when you execute your report.

Pain is stress leaving the body

DoubleD

 

[gset]

Hi,

Are you sure that you retreive all your rows in your SQL session and not only the first ones?

Graham.

 

[spicysudhi]

all rows.

 

[SivaSivaSivaSiva]

i) Have you tested your DataSourceName connection?
ii) Are your other reports are giving output in less time?

Regards,
Siva

 

[SivaSivaSivaSiva]

i) Have you tested your DataSourceName connection?
ii) Are your other reports giving output in less time?

Regards,
Siva

 

[Prasad678]

Sudhi,

did u chk the generated sql of ur query or tabular data?

One more suggestion:
Take ur oracle query, have a tabular sql in ur report and try acheiving the same report and see if u r still getting the same time delay.

I think if v can share any good or wierd behaviour of the tool it will help us a lot..

Prasad
RPrasad1@Chn.Cognizant.com