Exporting Slowness
If you are finding the exporting of forecasts or copy forecasts rather slow, we suggest upgrading your SQL Server from the standard LocalDB to SQL Express.
You can download a version from here.
Observed improvements on speed:
| Local DB | SQL EXPRESS | |
|---|---|---|
| New forecast creation | 13 sec | 5 sec |
| import forecast | 1 min 30 sec | 45 sec |
| export forecast | 8 min 51 sec | 5 sec |
Once SQL Express is installed, you will need point Forecast 5 to new the SQL installation and create a Forecast 5 database:
If you are already on a full SQL version, ensure that you have applied all patches.
Unpatched versions can attribute to the slowness.
Please check the system requirements here to ensure you reach the recommended specs