I want to create a dashboard that shows fresh DynamoDB data that comes in real-time. Using direct query mode for the dataset, the concept worked for low number of incoming events.
Now, having event rate at ~10 events / second, and after refreshing the dashboard just once, I need to wait for several minutes until I see the following on both of my visuals (a table and a bar chart:
It all depend on your database configuration. How much time taking to respond QS.
Filters are also the overhead on direct query. Every click generate a query for dB engine.
You can use the schedule refresh with minute work with 15 minimum. This feature available in Enterprise versions of QS.
Thanks. The point, still, is to make data refreshes on-demand instead of scheduled. There are two filters applied.
By database configuration, do you mean read throughput of the Dynamo table?