Support Board
Date/Time: Sun, 09 Mar 2025 00:52:20 +0000
Post From: Trade Activity Log taking a very long time to return data
| [2022-02-23 04:09:38] |
| User888593 - Posts: 9 |
|
First before starting new back test, make sure the existing data is cleared. You can tell by looking at the query count:
For the past month, this always took a second or two after clicking Clear Trade Simulation Orders & Data, no matter what kind of testing I had done, or the timespan. This is no longer the case, and the only thing that has changed in that span of time is rolling back the version. After the rollback, it takes ten to fifteen minutes. https://www.sierrachart.com/images/TradeActivity_QueryCount.png How long this takes, is dependent on your system hardware ( CPU and storage system):
Again, for the past month, before the rollback, this always took the same amount of time: a second or so. This was the timeline:2. When a subsequent backtest is started, SC begins deleting the prior TradeActivityLogs files one by one, taking between 0.5 and 1 second each. > Perform Backtest X (same backtest that has been run every day, multiple times a day, for one month, with very minor differences between tests). > When backtest finishes, results appear in less than one second, as always. > Update from version 2348 to version 2361. > Discover issue with Trade Activity Log "To" date. > Roll back to version 2348. > Perform Backtest X. > Results appear only after at least ten minutes. > Only resolution is manually wiping the TradeActivityLogs folder after each backtest. Go into the Backups subfolder in the Sierra Chart installation folder and clear the files from there. There probably are a lot of them.
There were over one million. Is it normal for SC to keep so many redundant backups?
|