Task Queue
SQL Editor manages user requests to run queries through the Task Queue system. This allows the users to efficiently handle multiple execution requests.
Execution process
SQL execution requests are processed in the following order.
When a user requests to run a query, it is converted into a Task and registered in the Queue.
The Task Queue manages tasks in a first-in, first-out (FIFO) fashion, with the first requested task being run sequentially.
When the currently running task is completed, the next task is automatically fetched from the queue and run.
The status of each task (Pending, Running, Completed, Error) is monitored in real-time on the Task List tab.
Checking the execution status
The users can check the status of each Task on the Task List tab.
The Task List tab area is created on the right side of the screen when The users select 
button] from the [View] menu, click the button on the Loading tab, or click the Progress Bar at the bottom of the application.
In the Task List tab, the users can view the following contents related to the selected editor session.
A list of running, pending, and completed tasks
A list of SQL contained within the Task
The type of Task
The start time of the task
From the Task List tab, The users can perform the following actions
Delete a task
Move to the editor where the Task was conducted
Benefits of the Task Queue method
Efficiency of concurrent tasks
Efficiency in monitoring the status of tasks
Ensuring the order of execution
Limitations
To ensure smooth system operation, the following restrictions apply when there are tasks running.
The execution of add-ons that use editor sessions is restricted. (Customize filter function, edit row function, etc. on Result Tab)
Changes to the editor session are restricted.
Change the status of Commit, Rollback, and Auto commit are restricted.
Last updated