performance tunning

[koolbachi]

Hi ,

When i am working with billions of data, i am not able to generate the report.

After running for  7 to 8 hrs not able to generate report.

But with limited data i am able to generate the report.

Thanks

[mikegreen]

So what is your question?

[koolbachi]

Hi,

I want to know how to reduce the time consumption?

how to tune the performance

thanks

[mikegreen]

Well, that is a very broad request.. probably BEST handled by finding a consultant to come in and do it for you if you are not familiar with data modeling, Cognos ReportNet, and your database system....  If you really are dealing with a billion row system, you need to talk to your DBA and find out how to query the system. 

Anyhow... First things I would look at -
How much time does CRN take vs the Database to return the query? Run the SQL in your native RDBMS query tool then compare to how long it takes the report to generate in CRN... CRN should only take a few minutes (maximum!) to make a report.

Try getting everything you can to be done in your database system.... make views/datamarts of aggregated data to only let CRN see the data it needs to make your reports/charts/etc.