Historical data downloaded from a data-feed are always saved in a local database. This allows you to significantly increase the performance of data loading and calculation when opening/refreshing the chart.
You can access Local Database Settings from Overcharts main window > Instruments menu > Local Database Settings
Every instrument has its own database. You can define a database default maximum size (in gigabytes). Default maximum size is the size applied by default to each single database.
For some instruments you can define a maximum size different from the default one (both larger and smaller). This gives you maximum control over disk space used by each instrument:
If the relevant checkbox is checked, you will be notified when database is close to maximum size.
After receiving the notification, you have the following options:
Database size can also be reduced. In this case, to actually apply the change to database you need to perform a database optimization.
You can change the folder containing all instrument databases at any time.
WARNING! If you are not experienced enough, DO NOT change default path. You may lose all instrument data.The success of the operation depends on many factors related mainly to your PC, your network and your experience. For this reason we CANNOT absolutely guarantee the success of this operation.
We do not recommend using an external or network hard-disk, unless the connection is absolutely performing in order NOT to reduce the performance in database reading/writing.
To change path follow these steps:
You can restore database default path at any time by pressing the Restore Default button.
From Database Monitor window you can monitor the database size of all instruments and highlight, by selecting the relevant checkbox, the databases close to maximum size.You can choose to optimize the highlighted databases by pressing Optimization Center button, or change database maximum size by pressing Database Settings button.
You can access Database Monitor from Overcharts main window > Instruments menu > Database Monitor
Database optimization compacts instrument database allowing you to recover disk space and increase database capacity.
You can access Database Optimization from Overcharts main window > Instruments menu > Database Optimization
To optimize the database of a specific instrument:
1) From Overcharts main window > Instruments Tab, select instrument to optimize
2) Right click > Optimize Database
On window open, a database scan of all instruments is automatically performed. Databases that need optimization will be highlighted. Press the Optimize button to perform the optimization.
The process may take a long time depending on database size and PC performance. We recommend you perform the optimization process outside trading hours.
To force the optimization of one or more instruments, even if not necessary:1) Press Add button and select all instruments to optimize2) Start optimization by pressing Optimize button
If after optimizing some instruments remain close to the maximum size, consider changing default maximum size (or only the maximum size of instruments involved) from Local Database Settings window.