How to compress the database

Questions about MultiCharts and user contributed studies.
thariman
Posts: 18
Joined: 21 Jul 2006

How to compress the database

Postby thariman » 21 May 2007

After deleting a lot of symbol. How do I compress or compact the database ?

User avatar
Kate
Posts: 758
Joined: 08 Dec 2006

Postby Kate » 21 May 2007

Currently it is not possible to compress our databases.

thariman
Posts: 18
Joined: 21 Jul 2006

Postby thariman » 21 May 2007

Kate,

How about what is the best way to export all the historical data and create a new database and reimport the data back ?

Guest

Postby Guest » 22 May 2007

Currently it is not possible to compress our databases.


Since MC uses a firebird database, can't users find our own solutions to this ?

Is the database password protected ? If it is , can we have the password to access it ?

thanks

User avatar
Kate
Posts: 758
Joined: 08 Dec 2006

Postby Kate » 22 May 2007

You can export data of the required symbols in ascii files, then you should delete TSStorage GDB, run MultiCharts installer and select Repair option to create a new TSStorage file and after that you will need to import data from the ascii files into QuoteManager. It's really a time-consuming procedure.

2

Postby 2 » 30 May 2007

Kate- in the same general theme as the first post in this topic can you explain exactly which file-s would have to be deleted in order to 'clean out the entire historical data base, and yet keep the symbols intact in the Quotemanager, so that when restarting or fixing MC there would be a clean data base started,and the symbols in Quotemanager would again request historical data from 'IB' to populate the data base?

In actuality, I am seeking to keep just the past 7 days of tick/volume/minute data for a dozen or so futures symbols on a perpetual basis.

Thanks


Return to “MultiCharts”