# How big your app can be? **URL:** \ **Category:** Ask for Help\ **Created:** [April 13, 2022, 2:45am UTC](https://community.glideapps.com/t/how-big-your-app-can-be/40676 "2022-04-13T02:45:55Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![SkrOYC](https://avatars.discourse-cdn.com/v4/letter/s/8e8cbc/32.png) [@SkrOYC](https://community.glideapps.com/u/SkrOYC)\ **Post date:** [April 13, 2022, 2:45am UTC](https://community.glideapps.com/t/how-big-your-app-can-be/40676/1 "2022-04-13T02:45:55Z")
I’m curious since I want to build a full ERP here. ## How big your app can be? Let’s formulate that differently ## How many tables and average rows can you have on an app before it could start to affect performance significantly? * * * I have an AppSheet app with around 40-45 tables and the biggest table have a couple thousand rows while the other ones are in the 200 range, some less than that. The thing is, to make Glide pricing more diggestable I would need to integrate other apps (10~ tables each one) into a big one. This shouldn’t be a problem (if Glide is able to be a 1-1 remplacement first, obviously) but I’m concern about performance issues with 60-70 tables on my app. Another interesting thing that I see is that as far as I know row owners is the only security filter available here that prevents the data to be sync to a certain device while I would need a lot of more flexibility there, considering different profiles for different users, even multi-company support on a single app… To the point # How big is your biggest app? (Table-wise mainly) ---
**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:** [April 13, 2022, 3:22am UTC](https://community.glideapps.com/t/how-big-your-app-can-be/40676/2 "2022-04-13T03:22:27Z")
> [@SkrOYC](#): > > How big is your biggest app? (Table-wise mainly) My biggest app is about 120 tables. It’s roughly a 50/50 split between Google Sheets and Glide Tables. The app is quite slow to load, but I believe that has nothing to do with the number of tables. Rather it’s more a function of the number of data rows (~30,000) and computed columns (~2000+) > [@SkrOYC](#): > > Another interesting thing that I see is that as far as I know row owners is the only security filter available here that prevents the data to be sync to a certain device while I would need a lot of more flexibility there, considering different profiles for different users, even multi-company support on a single app… Roles can be Row Owners, so that provides additional options, especially if you need multi-tenancy type functionality. ---
**Author:** ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)\ **Post date:** [July 19, 2022, 3:14pm UTC](https://community.glideapps.com/t/how-big-your-app-can-be/40676/3 "2022-07-19T15:14:41Z")
Hi Darren, I was looking on the forum for “ERP” since I got the question from a potential customer if we could do something like that with no-code tools. **Let me explain:** The potential customer is a fast growing company (currently ± 70 people) making industrial sorting machines. These are highly complex industrial machines that are more or less custom made for the end customers based upon a lot of components. They are using the ERP from their previous sorting company which was developed \>15 years ago using a mysql database and visual basic. The system is running on their own servers. Everything runs on user input and outputs and the system works great, only the input and outputs are absolutely not up to current standards. Would it be possible to build such a system on Glide, Google sheets or No-Code tools? Do you have any example projects you can show in order to show the level of complexity&size you can achieve and what issues you would run into? Or how would you advice to approach this? Many thanks for your advice, Best regards, Tim ps: should I make a seperate post from this? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 20, 2022, 12:48am UTC](https://community.glideapps.com/t/how-big-your-app-can-be/40676/4 "2022-07-20T00:48:14Z")
When you receive the input from the app, what do you expect the app to do to return the output? What is the “output” in this case? ---
**Author:** ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)\ **Post date:** [July 20, 2022, 3:33pm UTC](https://community.glideapps.com/t/how-big-your-app-can-be/40676/5 "2022-07-20T15:33:08Z")
Hi ThinhDinh, It really depends. What I meant is that all data gathered by the system is from manual User inputs (this should be doable in Glide) The app output should be that it updates the “central database” from which multiple views can be generated. It’s just that there are many parts and components in the system and many lines and I’m not sure if Glide would be able to handle the load & complexity. So therefore I was asking if there were examples of people that built ERP systems or alike. Or if you would recommend to keep using MySQL or someting different as a core database and integrate Glide Apps through API’s. Best, Tim ---
**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:** [July 20, 2022, 3:49pm UTC](https://community.glideapps.com/t/how-big-your-app-can-be/40676/6 "2022-07-20T15:49:24Z")
How big is the current database? If you’re talking about hundreds of thousands (or even tens of thousands) of records, then Glide is not the answer - at least not yet. But if the existing system has an API that you can work with, then using Glide as an intermediary user interface might be an option. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [July 21, 2022, 3:56am UTC](https://community.glideapps.com/t/how-big-your-app-can-be/40676/7 "2022-07-21T03:56:05Z")
Hola Tim The main problem with these cases (huge data) and Glide is the lack of client/server model and/or database pagination technique to manipulate this data. As you should know, Glide loads and puts entire data on your device and later, your APP works doing calculations, relations, etc. This is fine up to 20k-30k rows/registers but you need something smarter and more robust if your data is beyond the above limite. We talked about this and other things here: > [@Is Glide suited for developing open-ended data apps?](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631): > > I see developers creating open-ended data apps, like social media, messaging apps. What puzzles me is that when the app is used by thousands of users, the data alone would break 25,000 records. What then? You can’t remove/archive data to save on storage. Consider 1000 users posting 5 records per month. In 5 months, the app will have over 25k records. In view of this restriction, I find Glide apps only good for internal, mid-size data uses. Am I understanding this correctly? Saludos! ---
**Author:** ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)\ **Post date:** [July 21, 2022, 8:27am UTC](https://community.glideapps.com/t/how-big-your-app-can-be/40676/8 "2022-07-21T08:27:52Z")
Thanks Darren & Gustavo I read through the other Topic about the limitations. It seems we’ll have to wait on some upgrades on the Glide side. Airtable doesn’t really seem like the solution here or am i wrong? It also has a limit of 250k records. It’s a tough limit I think since I see plenty of applications for Glide in let’s say inventory management. However with some larger companies you quickly have well above 10k different assets. These assets need to be inspected at least once a year, some even every 3months. Then you have registrations which assets go to what location a few times per year. They buy new equipment to replace the old, so the database grows even bigger. I guess that in this situation after a year or so, the database will outgrow Glide and you’re stuck. Basically you would need to have some external database that can handle this and that easily integrates with Glide (for no-coders) because we don’t want to hassle with database management. Best regards, Tim ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 21, 2022, 1:01pm UTC](https://community.glideapps.com/t/how-big-your-app-can-be/40676/9 "2022-07-21T13:01:21Z")
> [@Tim\_Gestels](#): > > Airtable doesn’t really seem like the solution here or am i wrong? Yeah, this also falls under the 25k database limit. We hope the new computation model can lift some restrictions, but I’m not sure when it will be deployed, and how much can it help row-wise. Maybe you can try talking to Glide about the enterprise level to see if they can offer more rows. Personally I have never worked for a client on that level.