Support Board
Date/Time: Sun, 22 Dec 2024 11:53:27 +0000
Laggy issues
View Count: 1181
| [2015-07-30 18:22:06] |
| arrow - Posts: 52 |
|
I just upated SC to 1278 from 1250 something I believe. But I cant remember for sure. Running SC on 2 different PC's. They are both very laggy now. When I scroll charts back there is a stutter in the movement. The mouse cursor moves fine until I select a tool, I then get the same stutter delay. Everything was fine running all the same chartbooks before I updated SC. |
| [2015-07-30 18:43:11] |
| |
|
We are not aware of anything that changed which would cause this. You can run both of these versions at the same time by installing Sierra Chart into another folder on your system, and set them up to be 100% identical. You can then make a direct comparison. Refer to help topic 30: http://www.sierrachart.com/index.php?page=doc/helpdetails30.html Also take note of the most recent item 30.33: https://www.sierrachart.com/index.php?page=doc/helpdetails30.html#h30.33 So there is a particular Drawing Tool you are using which is causing this problem? If so, which one. We suspect this problem has to do with a particular graphics being drawn on the chart and whether you are linking charts. If you remove all the studies from the chart, do you still notice a problem? The other question is whether you are using a horizontal grid. Try removing that. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2015-07-30 18:43:49
|
| [2015-07-30 19:12:06] |
| arrow - Posts: 52 |
|
Thanks for the reply. It's not any one tool or linked charts. It's all tools and menus. I think I've narrowed it down to something with the spreadsheet. I can open a pervious version of my charts and spreadsheet and no stutter. |
| [2015-07-30 19:15:53] |
| |
|
OK are there any messages in the Window >> Message Log indicating some charts are being continuously recalculated?
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-07-30 19:29:15] |
| arrow - Posts: 52 |
|
The last recalculations I have are at 01:45:00 It is 12:30:00 now. I have a second instance of SC at v1224 when I open my chart and spreadsheet everything has a syntax error. I can try bringing it up to v125- I have earlier versions of my spreadsheet that work with v1278 and no lag. |
| [2015-07-30 20:03:17] |
| arrow - Posts: 52 |
|
v1259 has no lag issues running the same charts and spreadsheet on v1278 I didn't test beyond v1259. |
| [2015-07-30 20:13:51] |
| arrow - Posts: 52 |
|
The problem seems to be between v1261 and v1269 I have no lag on v1261 but I do with v1269. I did not try any of the pre release versions between 1261-1269 I'm using new spreadsheets (Tom wrote it) I know there were some bug issues being worked on? Something changed between these 2 releases that could have an effect on spreadsheets? |
| [2015-07-31 07:15:56] |
| |
|
There have been recent changes to Spreadsheets to solve some errors users were encountering and this has decreased the performance. The latest Sierra Chart versions, do not have any known bugs with Spreadsheets but the performance may not be as good as some earlier versions. Follow the instructions here, which are applicable, to reduce the Number of Rows used in the Spreadsheet to improve performance: https://www.sierrachart.com/index.php?page=doc/doc_Backtesting.php#ImprovingPerformanceSpreadsheets Attach the Chartbook you are using and the Spreadsheet file so we can test it to see if there are any performance improvements we can make. If it is not too difficult, please provide us a Chartbook which contains only a single chart. Here are the instructions to attach files: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile They can be attached privately. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2015-07-31 07:16:33
|
| [2015-08-03 16:18:10] |
| Sawtooth - Posts: 4141 |
|
There have been recent changes to Spreadsheets to solve some errors users were encountering and this has decreased the performance. The latest Sierra Chart versions, do not have any known bugs with Spreadsheets but the performance may not be as good as some earlier versions.
Due to the decreased performance of New Spreadsheets in recent versions, my client must use a version no later than 1261.Due to his system configuration, reducing the Number of Rows to improve performance is not an option. His system is complex and relies on a higher timeframe chart. Nonetheless, it is attached. |
Private File Private File Private File |
| [2015-08-04 08:38:50] |
| |
|
We are going to review this with our spreadsheet developer. But one comment. One thing that adds a lot of complexity and hurts performance is formulas like these: =MAX(AC3:INDEX(AC3:AC1002,MATCH(1,AL3:AL1002,0),1)) When there are dynamic references with the ':' operator, it adds complexity and hurts performance. Is there anyway these can be avoided. We are certain performance can be significantly improved and improved beyond that of the Old Spreadsheets, by not using these and the spreadsheet being set up to know this ahead of time. So what is the point of using them if they add programming complexity and hurt performance? If you require more formula columns, we can add more. And this is why it is important for us to be insistent that certain kinds of programming methods within spreadsheets are detrimental. Just because other spreadsheets have them and you want to use them, does not mean that in a real-time program they are good to use. Especially if we can take the performance drastically better and beyond that of Old Spreadsheets. Additional information: In other words, by not using dynamic range references, you are establishing ahead of time, the calculation order and dependencies. By using these dynamic range references, every single time a cell changes in the sheet, a lot of processing has to be done in order to determine the calculation order and dependencies. Even though this style of programming may be "elegant", is there an absolute definitive need for it without an alternative? That is our question. If there is an alternative, you can improve performance significantly by not using these dynamic range references and the spreadsheet being aware of that ahead of time. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2015-08-04 08:59:58
|
| [2015-08-04 19:23:45] |
| Sawtooth - Posts: 4141 |
|
But one comment. One thing that adds a lot of complexity and hurts performance is formulas like these:
A formula like this is only used in 2 of 46 formula columns, and when I delete both of them, performance is dramatically improved. Since the configuration only requires the MAX since the most recent event, I can move this formula to a single non-repeating cell, i.e. I won't use a formula column where 1000 rows are constantly updating. So the lag issue in this thread has been resolved.=MAX(AC3:INDEX(AC3:AC1002,MATCH(1,AL3:AL1002,0),1)) Using a formula like this in only 2 columns would not cause any noticeable lag in the Old Spreadsheets, so I'm not sure it's fair to say the comparative performance of the New Spreadsheets is significantly improved if the user must avoid certain formula types to achieve said significant improvement. I'm open for suggestions on another way to find the MAX of a dynamic range that doesn't cause performance issues. Date Time Of Last Edit: 2015-08-04 19:25:43
|
| [2015-08-04 19:31:03] |
| |
|
Using a formula like this in only 2 columns would not cause any noticeable lag in the Old Spreadsheets, so I'm not sure it's fair to say the comparative performance of the New Spreadsheets is significantly improved if the user must avoid certain formula types to achieve said significant improvement This has been something we have been working on for a long time now. It has not been easy. At times we have said that New Spreadsheets with some formulas are faster than Old Spreadsheets and we also acknowledge the performance problems where they are worse with certain kinds of formulas. This is one of those cases where performance is worse. I'm open for suggestions on another way to find the MAX of a dynamic range that doesn't cause performance issues. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2015-08-05 23:39:30
|
To post a message in this thread, you need to log in with your Sierra Chart account: