Database

Database – path to the Firebird database file.

Username – Firebird administrator username (“sysdba” by default)

Password – Firebird administrator password (“masterkey” by default)

Your SharpTrader™ database can grow because all the orders, sessions, and strategy logs are stored there. You can see the current database file size in the “DB file size frame”. We recommend your database file to be less than 500 MB, not to slow down the application. The smaller the DB size – the faster DB read /write operations are. When you see that the database file has grown in size significantly, you should click the “Remove garbage” button. In this case, special DB utility will clean the database from temporary information which is not used. If you check “Make backup,” the database backup image file will be created with the snapshot of the current database. If you need to restore one of the previous snapshots of the database, you will need to click the “RESTORE” button, and you will see the dialog:

In this dialog, select a file with the date of the backup you want to restore and click the “OK” button.

If the “REMOVE GARBAGE” operation did not decrease DB file size, you can clear strategy and session logs by clicking the “CLEAR LOGS FOR” button. You can select if you want to clear logs for a single session(strategy) or all sessions (strategies).