You’re right, that’s a lot and hard to do. I guess you can very well start with glide and see where you can go with it. Might take you pretty far…
@mthakershi In theory since Glide is using google servers for the back end storage and I assume similar back end servers for their other programs running the logic, and those back ends are set up to be fully scalable it should work. In practice who knows. Why don’t you get a bunch of your friends together and test it out
Let me speculate a guess that you are doing some kind of app that involves a soccer or cricket sporting event.
If you have 100 million people adding records, that will be well beyond the scope of google sheets.
As I understand it, google sheets has these limitations:
Up to 5 million cells for spreadsheets that are created in or converted to Google Sheets . 40,000 new rows at a time. maximum number of columns of 18,278 columns. Number of Tabs: 200 sheets per workbook.
Solution
Start with the known limitations for google sheets.
Do the math and find out how many google account spreadsheets and rows you will need to not reach max.
Create the relative amount of glide app you will need for each spreadsheet.
Create a main webiste that will divide and funnel your 100million users into the respective app according to some type of question, Location, Age, Gender etc. (Gender alone knocks you down to 50 million ( Age you can get down to another 10 million per age bracket). You may only need about 5 spreadsheets if you play your filters right.
After you have captured your data from 100 million users, Run a query with filter to combine only the relevant data you need from your 100 million user inputs
Tada there you have it. Hypothetical solution for your hypothetical app.
Glide will help you build and test functionality towards the point where you 100M users will need a full fat app and database… and business built to support all functional aspects.