Find what symbols/data is in the database

Login or Register

Please login or register in order to view and post in the Forum.

2 posts / 0 new
Last post
Sun, 05/23/2021 - 10:48
#1
MDavid
Last seen: 1 week 6 days ago
Joined: 09/16/2019 - 07:09
Find what symbols/data is in the database

I recently decided to create multiple instances of IRT per futures instrument I monitor in order to keep speed up, I went into quote page and removed all symbols by right clicking and choose "delete form database" except the single one I want to monitor in that instance but when I create a restore point with historical data they did not get any smaller since I removed all the additional symbols, is this the correct way to remove historical data or is there a better way? Am I able to view the data by instrument in windows file explorer and remove it that way?

0
Top
Mon, 05/24/2021 - 10:39
william-linn
Last seen: 1 week 5 days ago
Joined: 06/03/2011 - 00:00
Symbols and Historical Data

When you delete a symbol, all of its associated data is also deleted, e.g. all historical data, all trading history for the symbol, etc. Database restore points are highly compressed files so you may not see a major difference in the size of a restore points.

The Investor/RT database is composed of many files stored in the db folder (Iinvestor/RT 14). The Investor/RT 13 versions use an older database technology and keeps the files in the data_f folder. If you verify your database and then use the Data menu to open the Database Wizard (ALT+U) you can click on Database Log button to view each file, record type, record counts, etc. In this log, produced by the verification process, you can more readily see how deleting symbols has reduced the number of records used keep daily, intraday, and tick data.

Here is some sample output in the database log produced by RT 14, the names of the files and record types used for historical data are in bold.

Database Log: 2021-05-19 13:52:13
C:\Users\username\InvestorRT\db
00. File  0         dbf_hist_dat    0 References
01. File  1         dbf_tick_dat    8 References
02. File  2          dbf_symbol1    35 References
03. File  4          dbf_symbol2    7 References
04. File  6          dbf_symbol3    6 References
...
22. File 59         dbf_bars_dat    8 References

 0. Record 10005         sl_daily         56 Records          db\hist.db (0)    Referenced 2     Verified Okay
 3. Record 10004          sl_tick       2433 Records          db\tick.db (1)    Referenced 10     Verified Okay
 4. Record 10006        sl_symbol          8 Records        db\symbol.db (2)    Referenced 65     Verified Okay
...
56. Record 10070          sl_bars        419 Records         db\bars.db (59)    Referenced 10     Verified Okay
...
Verify Completed in 2.25 secs.
0 database errors found. 2021-05-19 13:52:15

 

 

Top