Cognos Performance Issue - Drill Through and Interactive Run

[wangy]

I am working with IBM technical support on this issue. I just want to share this with you and see if you have any ideas?

I found the drill through performance is much faster than the report interactive run. Just create one simple list report display 500 rows per page, and second report has one text item which drill through the first list report. Run the report one and two you will see the performance difference. I belive this problem happened on both C8 and C10. Interactive run includes any submit button, auto-submit, page down, up, etc. Here are the steps I recreate the issue in my C10 environment.

(1). Use GO Sales (query) package. Create first report called Drill-Through-Detail which simply display all columns in "Sales Staff" query subject.  Please set rows per page for list report to 500. The issue also related to rows per page. So set to 500 is important.
(2). Use GO Sales (query) package. Create second report called master which only have one text item "drill through" in the report. Define drill through for this text item and let it drill through the first report. No parameters needed.
(3). Run first report interactively, it takes 40 seconds. Run second report which is drill through the first same report, take 20 seconds.

Any ideas?

Thanks.

[Lynn]

Have you eliminated the possibility of caching? If you change the "Use Local Cache" property for the query in the detail report to "No" do you see the same behavior?

[wangy]

Use Local Cache set to NO. I don't want to use local cache so I can compare the true performance.