I'm experiencing speed issues - Forecast 5 is slow

I'm experiencing speed issues - Forecast 5 is slow

Issue:

I am finding Forecast 5 rather slow when making changes and moving between records.

Causes:
Some possible causes are:
1. Your PC and/or server is not meeting the recommended system requirements.
2. You are on a local database (this is the default option that comes with Forecast 5)
3. You have a large number of forecasts in your database.
4. Your forecasts use a large number of reference records, e.g. As % of Sales, As % of costs.
5. Your forecasts uses lots of hot links

Solutions:

1. Check that you are meeting/exceeding ALL the recommended System Requirements that are relevant to your license. Note there is a table for single users and another for servers, etc.
2. Upgrade to SQL Express. Forecast 5 uses SQL to store the database. SQL Express is a more powerful version that the localdb that is built-in to the Forecast 5 installer. See instructions on upgrading here.
3. Delete any unnecessary forecasts to clear space on the database.
4. Using reference records can impact the speed of your forecasts as they are doing a number of calculations. The above steps should help with improving the speed for these calculations.
5. Using a large number of Hotlinks can decrease the processing speed. Forecast 5 has a number of great functionality, including memos, calculate by units, etc. built in that you can use instead.

    • Related Articles

    • How to remap integration code to a forecast set up without the integration import

      If you have create a forecast with an integration but you did not import the data using the integration, the records will not be mapped to your chosen integrations GL Codes so importing data will not work. You can correct this using the steps below; ...

    • How to upgrade your Forecast 5 database to SQL Express on your local PC

      It is common for larger users of Forecast 5 to upgrade to SQL Express from the standard LocalDb. Upgrading to SQL Express or higher is strongly recommended for multi-user sites, licenses with consolidations and integrations, and network/server ...

    • Forecast 5 is not responding (or freezing)

      Issue I am trying to export or copy a forecast and it is taking a long time, then says it is not responding. Should I crash out? Answer No, do not crash out of Forecast 5. Although windows is saying that Forecast 5 is not responding, Forecast 5 is ...

    • Convert from your spreadsheet to Forecast 5

      To simplify your transition to Forecast 5, we have provided an easy step-by-step guide on converting your spreadsheet to Forecast 5. Open the excel budget. Save as a new spreadsheet. In the saved spreadsheet remove all totals and subtotals. Open ...

    • Possible Issues Of Running WPF Applications In Citrix

      While WPF has been around for a while, there may still be issues when running an application based on that technology within a CITRIX Environment. To help out our customers we have found the following CITRIX articles that may help you get the best ...