Number of Queries

[dssd]

If i have 2 report pages built using the same query. WOuld it fire two queries to the database or one?

[pumccg]

I re-discovered the answer to this one earlier this week in this forum - it will send 2.

[MFGF]

Yep - spot on! Two database queries would be executed.

MF.

[dssd]

How about two Data containers in one page going against the same query?

[MFGF]

Same story. Each container results in a separate db query being generated.

MF.

[pumccg]

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.