× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
nhilam reported 2018-12-03T15:16:29Z  · last modified 2019-07-12T21:55:29Z

Execute DB queries in background when opening workbook


customer request
Dev
QA
Nhi Lam
nhilam
Priority Low
Complexity Unknown
Component Visual Analytics
Version Future

I have 10 queries in my workbook.  The longest query takes 5 minutes, but serially they take 30.  I'd like to be able to run all my queries in parallel, so it takes only 5 minutes to open the workbook, not 30.

The implementation of this could be complicated due to many triggers in the code related to workbook loading.

As an alternative, we could do the query execution in the background during workbook loading so that the UI is not blocked during this entire 30 minutes.

There's a related issue that we have implemented in v19.5 where the query execution is done in the background during auto/manual refresh: Issue #13172

We could enhance this so that the query execution also takes place in the background during workbook loading. We'll need to make sure to execute the query for the selected worksheet first.

Issue #15652

In Progress
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017