I’m looking into an Appsheet project that will require to connect to a MYSQL database and pull a table of potentially 2 million records. The searches will be different per request so a saved search wouldn’t work.
I have found this article:
That seems to suggest a 5-10mb limit as the data is saved onto the device and has performance implications.
Is 2 million rows just completely out of the question? Some of the row data would be extremely long text values (HTML articles)
I’m thinking its just too much data and not a good fit for AppSheet but could do with some advice to be sure.