# šŸ™šŸ™\>25K rows in GT, or external database. So needed! **URL:** \ **Category:** Feature Requests\ **Created:** [February 11, 2021, 1:40am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594 "2021-02-11T01:40:45Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 11, 2021, 1:40am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/1 "2021-02-11T01:40:45Z")
Iā€™ve come to the point where I need Glide to scale. I have a client who paid $6.1K for an app, and he LOVES it, but we canā€™t get more than 50 users on it. He wants at least 300. We blow past the row limit because they make 8 row entries a day - we already blew past google sheetā€™s multiple simultaneous entries limitation. I am considering other no code tools now for this app, but that is the last thing we want to do. My client would absolutely pay for the extra storage, or the ability to connect to another database like Backendless. I need at least 2 million rows. Would love if Glide could give the option to scale! ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [February 11, 2021, 2:56am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/2 "2021-02-11T02:56:20Z")
> [@Errcomp](#): > > they make 8 row entries a day I donā€™t know if you can tell it, butā€¦ why this amount per user? Is this really needed? šŸ¤” ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 11, 2021, 3:20am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/3 "2021-02-11T03:20:20Z")
Yes, unless there is some other way to structure it. Its a habit app. Each user needs to complete 8 habits a day. It must be formatted as 8 buttons to press. Recording the entries as separate rows is important because the entries get rolled up into weekly, monthly, quarterly totals for a time vs points chart. Is there a way to fit this all in 25K rows? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [February 11, 2021, 3:41am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/4 "2021-02-11T03:41:53Z")
If you need to log every single habit completed per day and per user, I guess adding row is the only way to do it. If not, I know a way to save you ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 11, 2021, 6:09am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/5 "2021-02-11T06:09:43Z")
@Lucas_Pires How about charts per user? For example the monthly chart showing, Jan -21 points, Feb - 100 points, Mar - 87 points, etc. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 11, 2021, 6:19am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/6 "2021-02-11T06:19:32Z")
> [@Errcomp](#): > > Yes, unless there is some other way to structure it. Its a habit app. Each user needs to complete 8 habits a day. It must be formatted as 8 buttons to press. Recording the entries as separate rows is important because the entries get rolled up into weekly, monthly, quarterly totals for a time vs points chart. Is there a way to fit this all in 25K rows? Would it work as one row per user per day, with an 8 element array for the habits? (Habit 1, Habit 2, Habit 3, etc). I believe you can target individual elements of an array column with a rollup, so those should still work. ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 11, 2021, 6:58am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/7 "2021-02-11T06:58:26Z")
The only thing is even if we got it to 1 row per day per user, thatā€™s still 365 days \* 300 users = 109K rows. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 11, 2021, 7:01am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/8 "2021-02-11T07:01:30Z")
mmm, yeahā€¦ Once the data has been rolled up into weekly/monthly, do you still need direct access to the daily data? Wondering if you could process it, then offload to a separate spreadsheet on a regular basis? ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 11, 2021, 7:04am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/9 "2021-02-11T07:04:23Z")
Iā€™ve been thinking about that. But Iā€™d like it all to be automated. For this app, Iā€™m really starting to think we just need more rows, some way somehow. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [February 11, 2021, 7:11am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/10 "2021-02-11T07:11:05Z")
Thatā€™s what I meant by saying if you wouldnā€™t need to log every single habit completed, for example Like, e.g. using increment ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 11, 2021, 7:14am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/11 "2021-02-11T07:14:19Z")
I tried the increment, but I couldnā€™t make charts. If there was a way to periodically take the increment value and log it somewhere that could work. Havenā€™t been able to figure that out. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [February 11, 2021, 7:17am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/12 "2021-02-11T07:17:40Z")
Mmā€¦ well, itā€™s hard to explain now, but Iā€™m planning to post here a new method Iā€™ve created called _Trebuchet_. Funny name but it will open our minds to create new logics inside glide and take our apps to another level šŸ˜Œ I let you know when I post here ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 11, 2021, 8:39am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/13 "2021-02-11T08:39:29Z")
> [@Errcomp](#): > > Iā€™ve been thinking about that. But Iā€™d like it all to be automated. Should be pretty straight forward, eh? Could be done with any automation tool - Integromat, Zapier (I assume), or even Apps Script. ---
**Author:** ![DareSteps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daresteps/32/11716_2.png) [@DareSteps](https://community.glideapps.com/u/DareSteps)\ **Post date:** [February 11, 2021, 8:44am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/14 "2021-02-11T08:44:05Z")
This is going to be my issue soon too! Users submit many values on a daily basis. Mine is about check in, extra in and cover in where 18 admins check in 18 times a day plus extra in if they have free time to work plus cover in if someone is absent and someone else wants to cover him/her! Looking forward to your brilliant solutions as usual @Lucas_Pires ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [February 11, 2021, 10:54am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/15 "2021-02-11T10:54:11Z")
The best thing is to use another google sheet with filtering archived data and this also can be done using Zapier to input the data because you wont be able to do it through glide So use your forms to catch data in an empty sheet in the spreadsheet and then catch the data by zapier (new or updated row) Then delete the data to avoid the count 3rd step to insert it in the other google sheet So in the way above you will be able to use import range with filter and only show data to a certain dates or value Let me know if this needs to be explained more ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [February 11, 2021, 2:32pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/16 "2021-02-11T14:32:03Z")
Hola @Errcomp Have you tried to create the charts using [quickchart.io](http://quickchart.io) that way you could use some rollups and maybe save some rows? ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 11, 2021, 3:11pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/17 "2021-02-11T15:11:12Z")
Zapier and intergromat needs google sheets? I actually need it on Glide Tables. I hit google sheetā€™s limit on simultaneous entries but GT handles it great. I just need more rows šŸ™ For the suggestions from @Yasin_Hassanien @SantiagoPerez, @Lucas_Pires i think Iā€™d also need google sheets for those too, no? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [February 11, 2021, 4:31pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/18 "2021-02-11T16:31:13Z")
In my case, my method I use only glide ---
**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\ **Post date:** [February 11, 2021, 4:42pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/19 "2021-02-11T16:42:59Z")
Hey ! Based on the informations you mentioned I think that using the Glide spreadsheet may help you. You may want to check this topic : [https://community.glideapps.com/t/please-help-us-test-glide-sheets/14194?u=aymenm](https://community.glideapps.com/t/please-help-us-test-glide-sheets/14194) ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 11, 2021, 4:43pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/20 "2021-02-11T16:43:08Z")
@Lucas_Pires oh thatā€™s great! Iā€™ll be interested to see! Neat name too. [Next page](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594.md?page=2)