Performance

[Sudha]

Hi All,
I have a strange situation here,
I have a Report which has around 30000 Rows in the Output, which take a while to execute, but after a while it stops suddenly and it throws an error 'something saying unable to execute 'sqlOpenResult' error.

For the same Report if I use some filter conditions it's better and takes like 10 mins to excute.

I took the Generated SQL from CRN and ran against the DB and its fast just like that it gives the output.

My concern is how improve the Performance and generate Results Fast.

What are the steps...to be taken

Help in any way is appreciated
Thanks
Sudha

[asivaram_krishna]

1.We have to apply  as many filters
2.While publishing the pacakge in to cognos connection we have to check Governors in FWManager
3.In the database check the indexes..
(While inserting indexes in  to the database peroformance is low)

Siva