Decision Optimization

Decision Optimization

Delivers prescriptive analytics capabilities and decision intelligence to improve decision-making.

 View Only

Seeking Performance Optimization Advice for Planning Analytics Large Datasets

  • 1.  Seeking Performance Optimization Advice for Planning Analytics Large Datasets

    Posted 3 days ago
    Hi everyone, I hope you’re all doing well! I’m reaching out to see if anyone has experience optimizing planning analytics models for large datasets. I’m currently struggling with performance bottlenecks—specifically, long query response times and high memory usage when processing over 10 million rows. If you have insights or best practices—such as index design, aggregation strategies, or configuration tweaks—I’d greatly appreciate hearing them. I’ve already tried limiting dimensions and using incremental refreshes, but the model still feels sluggish during peak usage.
    Many thanks in advance for any advice you can share!