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
Related Articles
Forecast 5 User Guide
Contents Activating Your Forecast 5 License ........................................................................................................3 Having Trouble Activating Your Forecast 5 License? ...Forecast 5 Quick Start Guide
Contents Introduction to Forecast 5 ..................................................................................................................... 3 Creating a new Forecast ...Forecast 5 Demo Data
Downloaded and installed Forecast 5 and you aren't sure where to start? We have provided a demo data forecast that will help you see most of the features and benefits that Forecast 5 has to offer. Download the attached demo data (found at the bottom ...Version Control: Unable to access Forecast 5 after update
Issue: After running the update, Forecast 5 begins to load, the error below flashes and it closes down: "The Forecast 5 Client you are running has a newer version than the database you are connecting to. Ensure that the db user you are connecting ...How To Update Your Login Details
If you would like to personalise your username and password for Forecast 5, login to Forecast 5 with the default details: Username: Admin Password: (blank) Then go to Update Current User Change the username, enter the old password and enter a new ...