The method discussed in this article allows the dashboard to simply display the datasets rather than execute queries. This results in better overall performance of the gateway (queries are only ...

CREATE INDEX IDX_TIMER_TASK_NAME ON HUB_TIMER_TASK(taskName); CREATE INDEX IDX_TIMER_TASK_SCHED ON HUB_TIMER_TASK(schedulerId); CREATE INDEX IDX_TIMER_TASK_TYPE ON HUB_TIMER_TASK(scheduleType); CREATE ...