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 ...Update the config file - point Forecast 5 to a new server or database.
If you have a network license and you wish to store the Forecast 5 database on a server, you will need to update the config file to point to the correct server and database. On the server, go to this path: C:\ProgramData\Forecast 5 Ltd Edit the file ...Using bank accounts for shareholders payments and crediting to current account
How to set up shareholders payments and credit to current account Set up a P&L Cost as separately invoiced cost and call it “shareholders salaries” Create a bank account called “Drawings” Create an other debtor/creditor account (Other assets and ...Using Reset to No Actual’s
The Reset to No Actuals feature is designed to make the next year budget easier. This works by saving your actuals as the budget figures to then allow to you extend the budget into next year using these figures as the basis for extend and amend. ...