Canvas - on Load - Consececutive Queries instead of all at once .

Hasan Sd

Hii….Hope you're doing good . We have developed a Canvas on ADW having multiple charts/visualizations . When this canvas is loaded ,all the queries of all the charts are fired at once on the database . This is increasing the load drastically on the database . Is there any way to make sure that queries are fired consecutively to resolve this ? Pls advise . Thank you.

SteveF-Oracle

Hi @Hasan Sd,

Since you are using ADW, consider configuring your connection for the appropriate concurrency.

How To Choose The Best Oracle Autonomous Data Warehouse Database Service Name Connection Type for Oracle Analytics KB104245

https://blogs.oracle.com/analytics/post/choosing-the-proper-oracle-autonomous-data-warehouse-database-service-name-for-oracle-analytics-cloud

Hasan Sd

Dear @Gianni Ceresa , @SteveF-Oracle . Can you Please advise on how to resolve this issue ? Thank you in advance.