Performance impact of Multi Data Provider in WAD !!

[Former Member]

Hello Experts,

I am working on WAD reports with multiple Data Providers,

I.e. Web Template with DP1, DP2, DP3, DP4 --- Query 1

DP5, DP6, DP7, DP8 --- Query 2

Purpose - i have used Tab Strip Item with eight Tabs, each tab belongs to respective DP.

- Each Tab represent differnt view of the Report (using commands)

So, Does multi Data Provider with Multiple Queries have impact on Performance of the web report ? and If it does, then possible ways to improve performance ? Any advice/experience on this..

Many many thanks in advance.. Please help... Thanks

Regards,

Sunil Patel

[cornelia_lezoch]

Hi,

you could work with the settings for your queries in RSRT.

Ther you can define what data will be read when running a query and what is read when users are doing navigation in the query.

By changing the settings you might get some better performance.

Though working with aggregates has probably more effect on the performance.

regards

Cornelia

[Former Member]

Thank for the reply, i found this information very useful as i learned something new.

However, still not answer my question. i need some more information on how to restrict multiple querie start loading at the begining ? or How to get, query loads only with click on tab ?

Please help. Thanks