# Is Glide suited for developing open-ended data apps? **URL:** \ **Category:** Ask for Help\ **Created:** [January 3, 2022, 11:49am UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631 "2022-01-03T11:49:53Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Howard](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/howard/32/36858_2.png) [@Howard](https://community.glideapps.com/u/Howard)\ **Post date:** [January 3, 2022, 11:49am UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/1 "2022-01-03T11:49:53Z")
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? ---
**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\ **Post date:** [January 3, 2022, 11:53am UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/2 "2022-01-03T11:53:19Z")
Hey @Howard, So the limit of 25K rows is not actually a brick wall! You can go beyond that! Just that your loading time may increase a bit! So yes! Its possible to create open-ended data apps but its not recommended. Once AirTable or any other large database comes into picture, this may be easier to achieve. ---
**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:** [January 3, 2022, 12:33pm UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/3 "2022-01-03T12:33:21Z")
> [@ShantanuIyengar](#): > > Once AirTable or any other large database comes into picture, this may be easier to achieve. I really hope this might be the case, but if the problem lies in how many rows Glide can process then changing the database might not actually increase the rows limit. ---
**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\ **Post date:** [January 3, 2022, 12:35pm UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/4 "2022-01-03T12:35:08Z")
I will share an app soon! I achieved a connection between Glide Apps and MySql Database with over 1 Million rows. With pagination! It should be fine to load a lot more data than 25K rows ---
**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:** [January 3, 2022, 12:53pm UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/5 "2022-01-03T12:53:28Z")
Thanks! Looking forward to it. I was struggling a lot with connecting anything more than 15k, the builder loads very slowly so it’s hard to work. ---
**Author:** ![Howard](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/howard/32/36858_2.png) [@Howard](https://community.glideapps.com/u/Howard)\ **Post date:** [January 3, 2022, 1:57pm UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/6 "2022-01-03T13:57:24Z")
How did you manage to use MySql Database with Glide? Is this standard? ---
**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:** [January 3, 2022, 2:15pm UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/7 "2022-01-03T14:15:02Z")
I’d like to see it too 💪 The problem source is how Glide handles data, it’s not a classic Client–server model. Glide needs to use/read its internal databases (base on Firebase) and no matter what external “database” we try to use (GS, Excel, MySQL, etc), any updated or new row (or value) must be replicated to Glide database in order to be loaded and used on our APPs. Our data can be saved on our MySQL server but the data on our devices come from Glide databases ruled by Firebase and it’s a bottleneck unfortunately, the synchronization between both sources consumes time and resources. On small/mid-size APPs, load all data can be a good idea but on large ones the performance and manipulation problems appear as we know. Use **Pagination** to load data dynamically will be the missing piece that Glide needs to implement. Meanwhile, use a workaround like bellow to get data frequently without loading it might be an option; > [@A Google Sheet working as a REST API: good or bad idea? bomb](https://community.glideapps.com/t/a-google-sheet-working-as-a-rest-api-good-or-bad-idea/35668): > > Hola! It’s just a Proof of Concept which I wanted to do since a long time ago to know how reliable and fast a Google Sheet can handle a large amount of data and be used as an API to receive/send data frequently. As you should know, GS is not a native database therefore, some key functionalities (like an indexed file) don’t exist and can’t be used to improve the lookup speed. GS has the Filter() and Query() as tools to search data but it isn’t enough to make a lookup fast or optimal, both of th… Saludos ---
**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\ **Post date:** [January 3, 2022, 3:06pm UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/8 "2022-01-03T15:06:29Z")
So baiscally the pagination is what i achieved! Yes! Improvements are needed! Will share by EOD IST! So basically I had to recreate all the functions of add, update and delete using button and sql queries so that a large database is accessible and usable ---
**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:** [January 3, 2022, 7:40pm UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/9 "2022-01-03T19:40:49Z")
Pagination whwre exactly? ---
**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:** [January 4, 2022, 12:11am UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/10 "2022-01-04T00:11:12Z")
> [@gvalero](#): > > Our data can be saved on our MySQL server but the data on our devices come from Glide databases ruled by Firebase and it’s a bottleneck unfortunately, the synchronization between both sources consumes time and resources. Yeah this is what I thought. Thanks for sharing the idea! Great read. ---
**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\ **Post date:** [January 7, 2022, 12:58pm UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/11 "2022-01-07T12:58:51Z")
As promised! A few days later though! I posted my MySQL app on the Glide Community! You can view it here! > [@Glide App + MySQL](https://community.glideapps.com/t/glide-app-mysql/36805): > > Hey Gliders! This is the first version of Glide Table + MySQL app with over 1,30,000 movies. I’ll be very happy if you guys test it out! I have created Add Movie Delete Movie View Movie Pagination Let me know your views and suggestions in the comments This is just showcase! It may be a bit buggy! ---
**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\ **Post date:** [May 13, 2022, 11:09pm UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/12 "2022-05-13T23:09:45Z")
I will study more to get that points clearly. Thank you so much for sharing that information