📢
New Feature: Smarter Execution Handling to Optimize Performance
We’ve rolled out an enhancement that significantly
improves how GoodData Cloud handles long-running and abandoned SQL queries, boosting performance and resource efficiency across your analytics environment.
What’s New?
•
Automatic Cancellation of Abandoned Executions: GoodData Cloud now automatically cancels long-running SQL queries when no user is actively waiting for results. This includes:
◦ Requests supporting visualizations and filter dropdowns
◦ Running SQL queries in data sources
•
Real-Time Execution Optimization: Interacting with dashboards or Analytical Designer just got faster. When you:
◦ Change filters
◦ Swap metrics or attributes
◦ Interact rapidly with visuals
◦ …previous unfinished queries are automatically stopped. Only the most recent query runs—minimizing backend load.
Why It Matters:
1.
Optimized Resource Utilization: Frees up database resources by cancelling executions the UI no longer needs, keeping your system responsive and efficient.
2.
Faster User Experience: Reduces lag when exploring data, so users get the freshest insights without waiting on outdated queries.
3.
Improved Backend Efficiency: Especially helpful for environments accessing raw data sources with limited concurrency. Now, backend capacity is used more intelligently.
🎥
Watch the Demo: See cancellation in action and understand the benefits
Have questions or need help? We’ve got you covered!