I have a question for the AppSheet development team.
What’s the best way to design a data-heavy application? In my case, it will be 1.5-2 million rows.
This application is for internal use, it generates possible combinations of entities (keywords for SEO).
This data is not often used (changed), but it will be accessed by other data, of which there will be at least 3 million rows.
Is it worth trying to make a similar application on AppSheet. Will there be persistent problems with this amount of data (synchronization, performance on the device, errors when adding / updating large amounts of data, etc.)?
Will the purchase of the Enterprise Standard plan solve some of the problems and difficulties with scaling (we have few users, only 8 people).
I started doing tests and added about 45000 rows by an external request api in a batch way (500 rows at a time).
Then I increased the batch size to 1000 lines and got an error (this error is not displayed in the Audit Log panel). On packet 12, the AppSheet server gave an error (see the screenshot below).