- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.5K On-Premises Infrastructure
- 137.7K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Question on Reducing Calculation Time on Script
I have a calc script which takes 50 mns to run and would like to reduce the time it takes to run by about half. I've tried various things such are adding calcparallel and calctaskdim, which helps a bit. Below is a simplified version of the script.
The issue arises when running this script for all 50 states (plus some additional entries for international regions) - basically I need to sum up all states/regions into geo_combined and then perform some additional math (not shown here). Just the @sum() adds a lot of time to the calculation. Any input to improve on this simple calc is greatly appreciated... Thank you.
"geo_combined" = @sum( "geo_fl", "geo_ark", "geo_alaska", etc) * some_math...