Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: dssd on 12 Sep 2013 01:32:05 PM

Title: Number of Queries
Post by: dssd on 12 Sep 2013 01:32:05 PM
If i have 2 report pages built using the same query. WOuld it fire two queries to the database or one?
Title: Re: Number of Queries
Post by: pumccg on 12 Sep 2013 04:22:20 PM
I re-discovered the answer to this one earlier this week in this forum - it will send 2.
Title: Re: Number of Queries
Post by: MFGF on 13 Sep 2013 07:28:03 AM
Yep - spot on! Two database queries would be executed.

MF.
Title: Re: Number of Queries
Post by: dssd on 13 Sep 2013 09:59:13 AM
How about two Data containers in one page going against the same query?
Title: Re: Number of Queries
Post by: MFGF on 13 Sep 2013 10:00:21 AM
Same story. Each container results in a separate db query being generated.

MF.
Title: Re: Number of Queries
Post by: pumccg on 13 Sep 2013 10:49:18 PM
If you have identical lists in different containers in the one report I believe you can point all these to the same query, then set its SHARE RESULTS SET property to Y, and then apparently it only sends one query to the DB. The only problem is I don't know when I'm ever likely to have this scenario.
Text only | Text with Images