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