Although I’d had to go through the ‘delete the database and start afresh’ approach once before due to performance issues (at the guidance of NT support), I certainly did not want to do this again! The first time I ran this, keeping 180 days of trade data, it removed over 250 thousand trade records and took around 10 minutes. Performance was noticeably better afterwards when NT was doing DB operations. All good \ud83d\ude42 I now run this every week as part of preventative maintenance. I just have a batch file on my desktop with the command line in it and both clear flags set – regular maintenance is now a breeze. A typical run looks like this<\/p>\n\n\n\n All you need to do is extract the download to a folder and run the .exe per the above image from the command line. Instructions for usage will be shown, but it’s just a case of supplying the path to your Ninjatrader data folder along with the number of days of data you wish to keep, plus either or both of the 2 optional flags if you want.<\/p>\n\n\n\n A WARNING <\/strong> Did this utility do its thing and clear hundreds or even gigabytes of data from your store? (the latter is not uncommon!). Let me know. Cheers.<\/p>\n\n\n\n Download<\/strong>![\"\"](\"https:\/\/pjsmith.me.uk\/wp-content\/uploads\/2021\/02\/EtSbqpoWYAAHXfB.png\")
<\/a><\/figure>\n\n\n\n
THIS IS ENTIRELY UNSUPPORTED (BOTH BY ME, AND NINJATRADER).
YOU USE IT ENTIRELY AT YOUR OWN RISK.
It does back up your database prior to making any changes. You’ll find it in the DB folder with the date\/time tagged on the end, so in the worst case, it should just be a matter to rename the backup and you are back in business. I’ve had no issues and it does work perfectly fine for me. Ninjatrader support might freak at the idea, but given their software lacks the features to do this, and because the performance issues this utility addresses are common, I’m happy.<\/p>\n\n\n\n