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.