Hi all community friends,
for the past 2 months i have been trying to ideate / conceive and build small apps with appsheet and experiment with features that one can utilize to build apps, i see some gaps and some limitations on with feature set and tools available in appsheet.
Now its time for me to upgrade to real time production scenarios such as below: special note: both of these apps need to be as close to real time as possible meaning that as rows get updated the app need to reflect what event just happened and take action based on that. (one reason for why we plan to chose google sheets as backend datasource)
1)Example 1: Event Exit / entry app - where information is collected on who entered and exited and do some immediate action like specifying on what one can do, based on the time of entry / exit , and data collection and response to the event need to be as close and immediate based on the time of event. this scenario can exponentially increase based on event where 100's -200's of entry/exit is recorded. and multiply this with days of the event , it will easily become large with minimum of 500 rows in single day.
2)Example 2: Retail contact less pickup (customer stays in parking lot and notifies the store of pickup goods), (post covid has encouraged such contact less pickup scenarios in walmart or target stores) where customers will park in the parking lot and notify for retail store checkout on their products ordered that needs to be pickedup.
for both of these above scenarios, i m planning for having google sheets to start with as a datasource. but im also worried that every day there might be bunch of rows added 1 row per order , 200+- 500+ rows getting updated every day during peak periods. Im worried that as days progress the data source might become large with 1000's of rows in google sheets.(example for a 30 days scenario it might be multiplicative of 6000-10000 rows and so on ).
Anyone experienced issues when dealing with large sheets i.e large enough for appsheets to start having performance issues and eventually getting into a state of either loading slowly or customer fatigue setting in using the appsheet app's performance.
any suggestions on better alternatives to google sheets being the backend and appsheet behaving well with other datasources than google sheets. what backend would you rate to use for such kind of intense - high load scenarios where the size of tables would increase rapidly.
Simply put my question boils down to ,
1) how large and complex can the apps be built with google sheets as backend and appsheets on front end .
2)is there a load testing platform for appsheets and google sheets *backend) or other datasources being used or
3)Suggestions to help me relieve of my pain in assuming a scenario that my app will not fail in the production scenario's out there that can hit me big time.
Any information from any who can share your experiences with such apps in the community will be highly appreciated.
Special Thank you for those who spared time to read this in detail till the end and respond.
LinkedIn
Twitter
