Hi,
I have a simple list report.The report is running fine but when I apply sorting on any one of the two identifier columns,the report is taking a long time to run.
The report has a filter to show the records of last 20 days.Report is showing around 350000 records. Is there any way to reduce the run time?
Thanks in advance.
Regards,
Joker
350,000 records - really? Cognos is not meant as a data extraction tool ... just saying.
Can you quantify how much longer the report is taking with the sort? What is your data source? Is your package relational or dimensional? Are you using a detail filter on a dimensional data source (hopefully not)? If relational, does the database have indexes on either of your identifier columns? If you copy the report SQL into a native database query tool (e.g. SSMS, PL/SQL, QMF, etc.) does it take long to run? Does the generated SQL look correct?
Quote from: bdbits on 26 Aug 2014 04:46:15 PM
350,000 records - really? Cognos is not meant as a data extraction tool ... just saying.
Can you quantify how much longer the report is taking with the sort? What is your data source? Is your package relational or dimensional? Are you using a detail filter on a dimensional data source (hopefully not)? If relational, does the database have indexes on either of your identifier columns? If you copy the report SQL into a native database query tool (e.g. SSMS, PL/SQL, QMF, etc.) does it take long to run? Does the generated SQL look correct?
Hi,
Thanks for your reply..
Actually this was not a requirement and I was just trying it. The report was taking 8-10 mins to run. When I reduced the records to last 7 days it ran in less time.I was using a relational package.As I was sorting on primary key, I believe it was indexed.I believe it was actally not a problem as there were a large number of records.
Regards,
Joker