Database

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Database

The daytradr application uses 2 databases to store information. For those technically minded, we use SQL Server Compact CE database. The databases are located in My Documents/Jigsaw Trading/Database:

 

JigsawTrading.unk - the database containing tick sizes and symbols.

JigsawTradingPnL.sdf - the database containing order, fill and position history.

 

Note - you can delete either database when the application is not running. It'll get recreated on startup but you will of course lose the data that was contained in them.

 

With version 2.0.0.16 of daytradr, we introduced some basic database verification tools. The database can fail for one of 2 reasons

Database corruption. This is rare but it does occur. The database is a third party software and so beyond our control but is generally of very high reliability and performance. Sometimes, something as simple as a glitch in writing will cause corruption.

Hard Disk/Memory corruption. Again this is rare. Hard Disk corruption is theoretically more likely with an SSD than a regular hard drive as SSDs do have a finite lifespan. Memory can also fail and when it does, it causes what appears to be random bugs across a variety of apps. There are tools to check your memory and we advise you do so if you see multiple different failures/hangs of the software on your PC.

 

In App Database Consistency Checking

The first level of consistency checking introduced in 2.0.0.16 is what we call "In App" consistency checking. It's done while the application is running. There is zero overhead in this. A consistency check is done as the app interacts with the database. When an inconsistency is found, you will see this message:

 

If you do see the message, our advice is to restart daytradr. Obviously, it's not always possible to do that. Double check that the app is showing you the correct position quantities if you just placed a trade and if so, restart at the next possible opportunity. The database will be repaired when the application restarts. If the database repair reports a failure during repair, then close daytradr, delete the above files, start again and download instruments.

 

Verify Process

The verify process checks to see if the database has any issues. The database will be verified on startup every 7 days. There is also an option on the File menu to tell daytradr to verify the database the next time the application is started:

clip0251

 

If the verify finds no issues, you will see the following:

 

clip0252

 

If there are errors, you will see this message (or similar):

 

clip0256

 

Repair Process

The repair process checks to see if the database has any issues. There is an option on the File menu to tell daytradr to repair the database the next time the application is started:

clip0251

 

If the repair is successful, you will see the following message.

 

clip0254

 

If the repair fails, you will see the following message:

 

clip0255

 

As suggested in the error, at this point, the database have been deemed to be corrupt and will need to be deleted to repair them. We strongly recommend connecting to the Journalytix app (the basic version is free for Jigsaw users) so that your trade data is stored there permanently.