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