Limits on data size

[Boul]

Hello everyone,

I know that AppSheet is limited in data volume: 5MB/10MB and no more than 100,000 lines.
How to estimate the data volume of an AppSheet application?
I suspect Appsheet uses a columnar database which optimizes the memory space of the data.

My Proposal:
- Download the data to my PC locally
- Zip data

Does this give me a good approximation of the volume managed by my application?
Note : It's an application for PC !

Thanks in advance

[WillowMobileSys]

You are mixing limits.  The 5/10MB limit is PER APP on a mobile device.  This includes app and data size compressed.  This is data size compressed.  I have built some very large apps and have not yet hit this limit.  UPDATE:  I do also believe these limits are outdated and today's devices allow much larger apps and have larger data size limits.

The 100,000 lines refers to rows in a spreadsheet...a single sheet...and is a guideline.  An app will have multiple sheets and if you are constructing your data structure properly, it will be a very long time before you hit 100,000 rows in a single sheet.  Before then you will likely need to perform purging or archival to keep app performance healthy AND more than likely will have considered or actually moved to a database.

In most sheet based apps, you will NOT need to worry about app +  data size IF:

1. You build data structures that make best use of AppSheet (i.e. relational data tables).
2. Only present to the user data they NEED by using Security Filters to limit downloaded data or purging/archiving data in the datasource.

[SkrOYC]

---

@WillowMobileSys wrote:

The 5/10MB limit is PER APP on a mobile device

---

Hi John. I was not aware of this limit. Is there a comment on this in the docs? What does it refer to?

@WillowMobileSys 

[AleksiAlkio]

It's not documented more than that and for app creators it's impossible to calculate.

[WillowMobileSys]

Below is the excerpt from this article.  I mis-stated that its for both app + data.  I also believe these limits are outdated.  Today's devices allow much larger apps and data limits.