Millions of concurrent users and actions

Hello gliders,
I am exploring an App idea which has the following characteristics:

  1. Possibly 100 million concurrent users.
  2. Users will be active and performing add/fetch/update during a 3-hour period when certain event starts.

Can I accomplish this using glide with top-notch user experience?
Thanks for help.

100 million concurrent users? Than you will be loaded and can get build whatever you want!

1 Like

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 :slight_smile:

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.

1 Like

Good point @Jeff_Hager, I forgot about the Google sheet limitation!

1 Like

Nope. Not a soccer or cricket App :slight_smile:

1 Like

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.

With 5 million cells, assuming a minimum of 20 columns, that’s 250000 max rows per spreadsheet. That would require 400 apps.

Come on Glide. For $19/month you should be able to run the DMV database for every State in the Union.

If I have to go break it down by state it would cost like $1000 a month versus the $60 million it likely now costs taxpayers per year.

I can’t afford either of those rates, so please extend the free plan to include at least 250,000 rows for up to 100 apps.

Kidding, of course.

2 Likes

I like the bold colour of this vision. :smirk:

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.

1 Like