Exporting Slowness

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 DBSQL EXPRESS
New forecast creation13 sec5 sec
import forecast1 min 30 sec45 sec
export forecast8 min 51 sec5 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 ...
    • Hotlinks not holding

      Issue: When hotlinking to a spreadsheet, the figures pull through fine. But when exiting out of Forecast 5 and coming back in, the hotlink is no longer holding. Cause: This can be due to punctuation marks, e.g. ' (apostrophe), , (comma), etc. Because ...
    • Cannot open database "...." requested by the login. The login failed.

      Issue: When trying to open Forecast 5, you are receiving the error below: SqlException Cannot open database "Forecast5V3_2018" requested by the login. The login failed. Login failed for user 'Navsoft\JohnDoe'. at ...
    • License - The Given Key Was Not Present In The Dictionary

      Issue: When trying to run Forecast 5, you get the error message below: "The given key was not present in the dictionary"   Solution: Contact support@forecast5.com with the name of the computer you are having the issues with. They will clear the ...