# Lots of data to manage
**URL:** https://community.glideapps.com/t/lots-of-data-to-manage/35620
**Category:** Ask for Help
**Created:** [December 7, 2021, 11:35am UTC](https://community.glideapps.com/t/lots-of-data-to-manage/35620 "2021-12-07T11:35:32Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Jacopo\_Chiapello](https://community.glideapps.com/u/Jacopo_Chiapello)
#### Post date: [December 7, 2021, 11:35am UTC](https://community.glideapps.com/t/lots-of-data-to-manage/35620/1 "2021-12-07T11:35:32Z")
Hi,
I have been working with glide for about 2 years.
My biggest job with glide has registered over 100k users and now I’m worried about what will happen to my app because there is too much data inside.
Is it possible to speak to a glide expert to understand how I can prevent the damage?
Thanks
---
### Author:  [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)
#### Post date: [December 7, 2021, 12:42pm UTC](https://community.glideapps.com/t/lots-of-data-to-manage/35620/2 "2021-12-07T12:42:03Z")
You can check this out
> **[Row Owners](https://docs.glideapps.com/all/reference/security-and-per-user-data/row-owners)**
>
> A secure way to restrict access to certain rows
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 7, 2021, 12:46pm UTC](https://community.glideapps.com/t/lots-of-data-to-manage/35620/3 "2021-12-07T12:46:00Z")
As Shantanu noted, you can use row owners to bring down the number of rows the user has to actually download when they open the app.
However, if there are too many users at once trying to write data to your Sheet (if you’re using a Sheet) then you might have a problem. Do you build your database in Glide Tables or Google Sheets?
---
### Author:  [@Jacopo\_Chiapello](https://community.glideapps.com/u/Jacopo_Chiapello)
#### Post date: [December 7, 2021, 12:54pm UTC](https://community.glideapps.com/t/lots-of-data-to-manage/35620/4 "2021-12-07T12:54:11Z")
Shure, i use it.
I’m scared about Google sheets limits. I think the problem can be Google sheets not Glide.
---
### Author:  [@Jacopo\_Chiapello](https://community.glideapps.com/u/Jacopo_Chiapello)
#### Post date: [December 7, 2021, 12:58pm UTC](https://community.glideapps.com/t/lots-of-data-to-manage/35620/5 "2021-12-07T12:58:11Z")
We build all on Google sheets, whit some script for some fuctions.
---
### Author:  [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)
#### Post date: [December 7, 2021, 1:39pm UTC](https://community.glideapps.com/t/lots-of-data-to-manage/35620/6 "2021-12-07T13:39:07Z")
You can try to move rows which aren’t being used to other sheet.
> [@Scripts, scripts, scripts!](https://community.glideapps.com/t/scripts-scripts-scripts/18965/48):
>
> A script to move rows from one sheet to another based on certain conditions. I run this trigger every 24 hours to get rid of past data and save it as a backup so my apps are always easier and quicker to load. function moveRows() { var ss = SpreadsheetApp.getActive(); var source = ss.getSheetByName('Sheet1'); var val = source.getDataRange().getValues(); var PDate = new Date(new Date().setHours(0,0,0,0)) for (var row = val.length - 1; row \>= 0; --row) { Logger.log("C…
---
### Author:  [@Jacopo\_Chiapello](https://community.glideapps.com/u/Jacopo_Chiapello)
#### Post date: [December 7, 2021, 2:59pm UTC](https://community.glideapps.com/t/lots-of-data-to-manage/35620/7 "2021-12-07T14:59:19Z")
This look interesting, i try to undestand if possible to do this.
Thanks
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [December 7, 2021, 4:59pm UTC](https://community.glideapps.com/t/lots-of-data-to-manage/35620/8 "2021-12-07T16:59:20Z")
If you are concerned about reaching limits in Google Sheets, you might consider moving your data to Glide Tables. It could be a lot of work to migrate and then rebuild.
For the migration part, check out this post by @Krivo
> [@robot Importing data to Glide by use of robot (RPA)](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008):
>
> Challenge 1 In this moment of time it is not possible to import data (or paste chunks of data) into Glide. @Manu.n has shown a way to import a row at a time from Google sheets to Glide tables which is quite handy if you have not to much data to import. But if you have hundreds or thousands of rows this approach is not the way to go.
>
> > **Manu.n's approach - great for a smaller number of rows**
> >
> > \
### Author:  [@Jacopo\_Chiapello](https://community.glideapps.com/u/Jacopo_Chiapello)
#### Post date: [December 7, 2021, 5:11pm UTC](https://community.glideapps.com/t/lots-of-data-to-manage/35620/9 "2021-12-07T17:11:24Z")
We use some script in Google sheets and we can’t go only on glide.
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 7, 2021, 5:48pm UTC](https://community.glideapps.com/t/lots-of-data-to-manage/35620/10 "2021-12-07T17:48:33Z")
There’s an old trick I used to use when I was using Glide regularly. You can use a separate google sheets workbook to store data. in that workbook you have a page pull the data you need to lookup into it. Then the workbook thats not associated with glide will run its lookup with that data and return just the results you need. And finally in your glide associated google sheet it does the same thing and as the other sheet and has a page that equals the resulted query.
Or you can run a script to export the JSON of the non associated sheet and use that as a Query in Glides sheets to pull the data in a similar manner.