I am building a CRM but a lot of my clients have over 10.000 contacts. I know there is a certain limit within Coda. Is this something we can use Coda for? Or is it advised against?
The “10,000” limit on Coda rows is not a hard limit like the number of rows in Excel. It is more a rule of thumb that says around ten thousand lines in a single table will start causing some performance issues. (Also depending on the kind of columns used in the table.)
But there are many mitigating strategies that one can follow: Separate tables, separate docs, etc. The design woud be extremely important.
Thanks for the info. What types of columns are best avoided?
My comment would have been more accurate if I had said “Also depending on the formulas used in the columns in the table.”
There is basically no limit to the calculations that you can do in a formula in a column, so that can dramatically influence performance.
I also do hope that some of the other members of the forum with experience in this area will comment after the weekend.
For example - I do not know what the impact of canvas columns would be on the doc. But they are a complex column type. It might have a major impact, or Coda might have found a way of isolating the performance of a table from what is happening in the canvas column. I just don’t have enough technical knowledge to comment.
Nice to e-meet you! I am part of Coda’s Success team - we are here to make sure that Coda Makers have all the tools they need to succeed.
I am happy to talk live through some tips and tricks for doc schema and set up if it would be helpful. You can access my calendar here!