Local Database

Table of Contents

Local Database Settings #

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.

Access Local Database Settings #

You can access Local Database Settings from Overcharts main window > Instruments menu > Local Database Settings

Database Size #

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:

  1. Select Size Tab
  2. Press Add button
  3. Select instruments to customize and press OK
  4. Define new maximum size of database for each added instrument by selecting the size on the relative combo-box in the grid
  5. Press OK to confirm changes

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:

  1. Increase default maximum size applied to all instruments.
  2. Increase database size of the single instrument (all other instruments will continue to have the maximum default size).
  3. Perform a database optimization (see below)
  4. Do nothing and to stop receiving the warning uncheck the relevant option. In this case, instrument database will keep the maximum size and the oldest data will be deleted to make room for new data.

Database size can also be reduced. In this case, to actually apply the change to database you need to perform a database optimization.

Database Path #

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:

  1. Select Path Tab
  2. Press Change Path button and select the new destination folder
  3. Choose what to do with current database:
  • No action (leave old database unchanged for next reuse)
  • Move database to the new path
  • Delete database (all data will be PERMANENTLY deleted)
  1. Press OK to confirm changes
  2. Restart Overcharts

You can restore database default path at any time by pressing the Restore Default button.

Database Monitor #

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.

Access Database Monitor #

You can access Database Monitor from Overcharts main window > Instruments menu > Database Monitor

Database Optimization #

Database optimization compacts instrument database allowing you to recover disk space and increase database capacity.

Access Database Optimization #

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

Optimize #

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 optimize
2) 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.