Support Board
Date/Time: Sun, 22 Dec 2024 11:20:23 +0000
Post From: Laggy issues
| [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
|