Roll20 uses cookies to improve your experience on our site. Cookies enable you to enjoy certain features, social sharing functionality, and tailor message and display ads to your interests on our site and others. They also help us understand how our site is being used. By continuing to use our site, you consent to our use of cookies. Update your cookie preferences .
×
Create a free account

Extremely long repeating sections with calculations... very very slow?

Hi, I've got a need to create an event log for players to enter notes into. This needs to be a repeating section, not just a text window. Mostly because it's a lot of repeating events that have the same structure (like police case notes) but also because there's a need for a fair amount of math on more than one field in the repeating sections. For example, each repeating section has a "Duration" field, which needs to be filled in each time. And then those durations need to be added up and have further math done on them that relates to other attributes around the sheet. The issue I ran into years ago (that stopped me from doing this back then) was that more than half a dozen entries would grind the whole Roll20 page to a halt as it recalculated everything each time any change was made to this section. The more sections, the slower it got till it was quickly unusable. Is this still a thing? Can one not do calculations in repeating sections without grinding to a halt? Is this something sheet workers can do now?
1586683607
GiGs
Pro
Sheet Author
API Scripter
There's no reason such a section should grind roll20 to a halt. It's likely the method you used to build the section was inefficient. If you're relying on lots of individual sheet workers cascading through to perform the calculations, then it can take a long time, but if you use one sheet worker that collects all the attribute values and does the calculation when any of them changes, it should be quite speedy. Can you post your repeating section, and the sheet workers you use, and the calculations needed, and we can help you make it efficient.
Thanks. I'll do that.
1586695638
GiGs
Pro
Sheet Author
API Scripter
From your other thread, i might have underestimated the size of these repeating section - a section with hundreds of rows might slow the sheet down. But if built carefully, I am optimistic it could be manageable. It's hard to see without seeing details though.
No doubt. This one will take me a while to even begin with. Don't hold your breath. Thanks for all your generous help with the other topics though.