Request your clarification on the following topic.
The help documentation about AppSheet database mentions that Enterprise plan apps can have 200,000 rows per database and maximum 20 tables any plan can have.
Is it correct understanding that these limits are not evenly distributed per table ?
Edit: After posting above, I came across the following post thread which suggests that a table in ASDB can have 50,000 rows for an optimum performance. My request will be confirm it and update the help documentation accordingly.
Hi @Suvrutt_Gurjar , you may distribute rows however you see fit in your database. Tables don’t have to all have the same number of rows, it just has to add up to 200k for Enterprise plans. Is this what you were asking about?
We did not add the 50k rows per table number to documentation because we have scaled AppSheet databases to hold more than that now. Also, it was causing confusion because most plans have a lower per database limit than 50k.
Thank you very much @ShirleyN for your clarification.
So my understanding based on your guidance is, a single table in an app having ASDB can hold much more than 10 K records ( even 50 K or more) in an Enterprise plan as long as the addition of the rows of all the tables in that ASDB is up to 200 K rows.
@Suvrutt_Gurjar You’re Welcome sir. Last year I read somewhere that ASDB Performance is improved a lot. So I tested 10K Records in Google Sheet vs ASDB. And the performance improvement was noticeable for all operations. The only problem I see here is people who are not on Enterprise Plus Plan. Because with limitation of 2500 rows per Database is not good.
