# Millions of concurrent users and actions

**URL:** <https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324>\
**Category:** Ask for Help\
**Created:** [November 23, 2019, 9:23am UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324 "2019-11-23T09:23:29Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)\
**Post date:** [November 23, 2019, 9:23am UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324/1 "2019-11-23T09:23:29Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [November 23, 2019, 9:48am UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324/2 "2019-11-23T09:48:32Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Secura\_4x4](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/secura_4x4/32/1513_2.png) [@Secura\_4x4](https://community.glideapps.com/u/Secura_4x4)\
**Post date:** [November 23, 2019, 11:55am UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324/3 "2019-11-23T11:55:53Z")

</div>

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…

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [November 23, 2019, 12:16pm UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324/4 "2019-11-23T12:16:11Z")

</div>

@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.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 23, 2019, 2:27pm UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324/5 "2019-11-23T14:27:05Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [November 23, 2019, 2:36pm UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324/6 "2019-11-23T14:36:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)\
**Post date:** [November 25, 2019, 6:05pm UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324/7 "2019-11-25T18:05:56Z")

</div>

Nope. Not a soccer or cricket App 🙂

---

<div class="post-metadata">

**Author:** ![Lighted\_Candle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lighted_candle/32/29544_2.png) [@Lighted\_Candle](https://community.glideapps.com/u/Lighted_Candle)\
**Post date:** [November 25, 2019, 7:42pm UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324/8 "2019-11-25T19:42:14Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 25, 2019, 7:58pm UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324/9 "2019-11-25T19:58:47Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Les\_Henderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/les_henderson/32/1142_2.png) [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)\
**Post date:** [November 26, 2019, 12:44am UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324/10 "2019-11-26T00:44:21Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Paul](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paul/32/1345_2.png) [@Paul](https://community.glideapps.com/u/Paul)\
**Post date:** [November 26, 2019, 2:51am UTC](https://community.glideapps.com/t/millions-of-concurrent-users-and-actions/2324/11 "2019-11-26T02:51:33Z")

</div>

I like the bold colour of this vision. 😏

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.
