Thanks for raising this. Performance issues like that can definitely start to show up as tables grow.
We recently hosted a roundtable on the future of tables and databases in Coda, and some of the updates coming this spring focus on scale and performance improvements for larger datasets. It may not address this exact scenario directly, but some of the architectural changes could help with situations like the one you described.
If you’re curious, here’s the recap from the session.
I’d also love to stay in touch once these updates roll out and see whether they improve the behavior you’re seeing, or if this is still something we should continue digging into.