database-concepts

Startup Manager

The Startup Manager offers users a variety of troubleshooting tools for interacting with a database that may be damaged.

Eliminating Bad Ticks

There are several methods for doing this. Please note that none of these methods are nowadays needed for the futures live streams we are getting from IQ feed, Rithmic, CQG or Interactive Brokers. For stock data reception, depending on the exchange, this might still have some interests. In all cases, a single bad tick may still happen on every market and the manual method discussed below always offers an efficient way to eliminate such outliers.

Installing on a Solid State Drive (or any secondary drive)

This article assumes you already have Investor/RT successfully installed on your computers main drive (for most users, this is the C:Drive). If this is not the case, and you are installing for the first time, install Investor/RT as you normally would (allowing it to install in its default location on the C:Drive). Then launch IRT for the first time to initialize the Database. Once you have successfully launched IRT, press Ctrl Q to quit.

Moving your Database to Another Computer

Windows

  1. On the source computer, create a Restore Point by opening Investor/RT and going to File→Functions→Create Restore Point. Choose to Include historical data.  If you exclude historical data (the default), you will have to download historical data for all symbols on the target computer.

Restore Points

Database Restore Points

In Investor/RT Version 11 and after, users can create single or Periodically scheduled Restore Points that can be accessed at a later time in case of an unexpected loss of data or, if a user wants to move the database to another machine . When creating a Restore Point, users can include or exclude Historical data.

Tune Up

Follow these steps periodically to keep Investor/RT running as healthy, lean, fast, and efficient as possible.  Users are recommended to perform a tune-up every 3-4 weeks if not more frequently:

Database File Limits

These tools have been developed for legacy versions of Investor/RT (13 or older) which were 32-bit applications. Investor/RT14 and higher use a 64-bit database, removing past size limitations of earlier 32 bit versions

Diagnosing Historical Database Usage

Send Database to Support

At some point, you may be asked by our support team to send a copy of your database to us for testing. Use the Restore Point Feature as outlined below:

To create a new Restore Point, go toFile→Functions→Create Restore Point. Be sure to set whether you'd like to include or exclude historical data as shown below. The file will be saved in the archives directory at:

C:\Users\YourUserName\InvestorRT\archives\ where YourUserName is the name you use to log into Windows.