{"id":444,"date":"2021-06-01T13:47:00","date_gmt":"2021-06-01T13:47:00","guid":{"rendered":"https:\/\/www.overcharts.com\/en\/helpcenter\/?post_type=docs&p=444"},"modified":"2023-05-25T12:09:16","modified_gmt":"2023-05-25T12:09:16","password":"","slug":"local-database","status":"publish","type":"docs","link":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/local-database\/","title":{"rendered":"Local Database"},"content":{"rendered":"\n

Local Database Settings<\/strong><\/h2>\n\n\n\n

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.<\/p>\n\n\n\n

<\/div>\n\n\n\n

Access Local Database Settings<\/strong><\/h4>\n\n\n\n

You can access Local Database Settings from Overcharts main window<\/em> > Instruments<\/em><\/strong> menu > Local Database Settings<\/em><\/p>\n\n\n\n

<\/div>\n\n\n\n

Database Size<\/strong><\/h4>\n\n\n\n

Every instrument<\/strong> has its own database<\/strong>. You can define a database default maximum size (in gigabytes<\/em>). Default maximum size is the size applied by default to each single database.<\/em><\/p>\n\n\n\n

For some instruments you can define a maximum size different from the default one<\/strong> (both larger and smaller). This gives you maximum control over disk space used by each instrument:<\/p>\n\n\n\n

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

    <\/p>\n\n\n\n

    If the relevant checkbox is checked, you will be notified when database is close to maximum size.<\/strong><\/em><\/p>\n\n\n\n

    After receiving the notification, you have the following options:<\/p>\n\n\n\n

      \n
    1. Increase default maximum size<\/strong> applied to all instruments.<\/li>\n\n\n\n
    2. Increase database size of the single instrument<\/strong> (all other instruments will continue to have the maximum default size).<\/li>\n\n\n\n
    3. Perform a database optimization<\/strong> (see below)<\/li>\n\n\n\n
    4. Do nothing<\/strong> 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.<\/em><\/li>\n<\/ol>\n\n\n\n

      <\/p>\n\n\n\n

      Database size can also be reduced. In this case, to actually apply the change to database you need to perform a database optimization.<\/em><\/p>\n\n\n\n

      <\/div>\n\n\n\n

      Database Path<\/strong><\/h4>\n\n\n\n

      You can change the folder containing all instrument databases at any time.<\/p>\n\n\n\n

      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.<\/p>\n\n\n\n

      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.<\/strong><\/p>\n\n\n\n

      To change path follow these steps:<\/p>\n\n\n\n

        \n
      1. Select Path<\/strong> Tab<\/li>\n\n\n\n
      2. Press Change Path<\/strong> button and select the new destination folder<\/li>\n\n\n\n
      3. Choose what to do with current database:<\/em><\/li>\n<\/ol>\n\n\n\n