Defer/optimization computation of tables inside canvas column?

[Ed_Wei]

When I load my page, I see that the majority of the time is being spent computing formulas in tables of embedded canvases.

• How can I optimize the page load time? Any way to defer the computation of the embedded canvases until when they need to be rendered?
• Should I avoid this pattern of tables in canvases due to performance reasons?

[Shaina_Torgerson]

Hey @Ed_Wei ! It sucks that your Coda doc is going slow . We feel your pain as we have a few big docs we use internally that have similar issues and it can be very frustrating. We do have people dedicated to improving doc performance, but as it’s a large area we can’t promise your doc will be fast tomorrow.

In the meantime, we recommend checking out some of the tips in these articles to help improve your doc’s performance:

• Improving Performance

• Troubleshooting calculation performance issues

• Troubleshooting rendering performance issues

• Optimizing slow formulas in your doc

Please let us know if any of those articles help you out!

[Agile_Dynamics]

@Ed_Wei,

i recently upgraded to a newer laptop and, because i edit videos a lot, i went for a large amount of ram (64Gb).

and suddenly, coda started performing much faster!

this led me to deduce that coda is a memory hogging beast.

so on my old laptop, i shut down everything and only open a single coda doc at a time, and notice it runs faster when it has access to all the ram.

another trick i have used to overcome this slow-to-open doc issue, is to keep that big monster doc open permanently. by setting my windows parameters to go to sleep (when i close the lid) and hibernate (when i press the power button) so the document never needs to reload.

(i did this to deal with poor internet connectivity, so i can work on the doc even when the internet connection is gone. but discovered an unexpecyed benefit was not needing to reload the doc from scratch several times a day.)

now, i DO shut down the whole system every now and then to keep windows stable etc.

just thought i would throw that out there in case it helps.

respect
max

[Ed_Wei]

Thank you for the thoughtful response. With the help of coda support, we identified orphan tables that were eating into the run time. Orphan tables are tables that remain even after they have been deleted. This is a bug in Coda which the team has taken back to find the best fix.

My doc is much more speedy as a result and now I am armed with tools to self diagnose.

My laptop only has 32GB of RAM. My team will have less. To prepare for the future, I’ve created a scale test for my doc and started improving or eliminating features that I find to be bottlenecks. If nothing else works out, I may consider using an external database that I integrate with Coda packs.

About my orphaned views:

Orphaned Views in Doc Map

So working on a doc I’m trying to recreate a Quicken type register. It was working. I went to make some changes and nothing would work right. Doc just kept popping up with “Wait” or “Exit” popup. I started abandoning columns and recreating them from scratch thinking there was some corruption. I deleted rows some contained Canvas columns. Now I find that there are over 400 Views of one table that are all “abandoned”. The only way I can find to remove these views is clicking each one in the…

About my attempts to improve performance:

How to improve the speed of a limit N rows table collab filter?

I would like to improve the performance of ~200 rows each with about 100 columns. I’ve attempted to create a table filter which enables me to filter the rows first by a text search and then by a limit in the number of results. This order of search first is important to me because I want the search to function find the entry even if it is not in the last N results. However, this filter is slow “Table collab filter” now shows up as as a slow step when measuring the performance. What my filter l…