# Need expert feedback on the 25k max line celling

**URL:** <https://community.glideapps.com/t/need-expert-feedback-on-the-25k-max-line-celling/41605>\
**Category:** Ask for Help\
**Created:** [May 4, 2022, 7:31am UTC](https://community.glideapps.com/t/need-expert-feedback-on-the-25k-max-line-celling/41605 "2022-05-04T07:31:27Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**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 4, 2022, 7:31am UTC](https://community.glideapps.com/t/need-expert-feedback-on-the-25k-max-line-celling/41605/1 "2022-05-04T07:31:27Z")

</div>

Please i need some expert feedback on that.  
i am planning to build a set of tools for project management within one container in our case it is (Pages).

i really see the Pages are promising for my project but i am really confused about its data limits.

i am planning to have different Clients owns different projects, the inventory module can consume almost 20k row per Client, and Inspection module will consume from 25k to 50k row per project and so on for budgeting module and project specifications and drawing module.

Logically, the data for each owner MUST NOT expose to other Clients, so each client has his own data and also each project data will not be exposed to the same client’s project except for the top management. which they will require reports and overall.

**Kindly** advise on the best structure to accommodate that scenario of my next project to fit with Glide.

i may split the entire project tools to be a copy of the same (Pages or app) for every different client, but that will be a real headache to manage many apps of the same identical structure for each client.

i am using google sheets for the time being just to construct the base and functionality, but i may shift to Mysql platform when growing as planned.

is it easy to shift from glide based on google sheet to Glide based on Mysql ?  
actually, it is many questions, sorry for that.

However, your advise will help me to procced and plan the overall structure.

---

<div class="post-metadata">

**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 4, 2022, 5:03pm UTC](https://community.glideapps.com/t/need-expert-feedback-on-the-25k-max-line-celling/41605/2 "2022-05-04T17:03:00Z")

</div>

i hope Experts find this 👋

---

<div class="post-metadata">

**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:** [May 4, 2022, 8:32pm UTC](https://community.glideapps.com/t/need-expert-feedback-on-the-25k-max-line-celling/41605/3 "2022-05-04T20:32:33Z")

</div>

Hola de nuevo! 😉

Your case is special and according to what I have read in your description, your APP can grow very fast. If your data will become in a historical database over time (no interaction/changes and only queries to find out values), maybe creating something like an API can be useful for you.  
Take a look at this thread to understand my idea and possible solution (depending on case of course)

> [@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…

---

<div class="post-metadata">

**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:** [May 4, 2022, 8:36pm UTC](https://community.glideapps.com/t/need-expert-feedback-on-the-25k-max-line-celling/41605/4 "2022-05-04T20:36:47Z")

</div>

Am using appscript and workarounds to retrieve history

---

<div class="post-metadata">

**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 4, 2022, 9:06pm UTC](https://community.glideapps.com/t/need-expert-feedback-on-the-25k-max-line-celling/41605/5 "2022-05-04T21:06:03Z")

</div>

i defiantly will read that article, thanks dud 😉

---

<div class="post-metadata">

**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 4, 2022, 9:06pm UTC](https://community.glideapps.com/t/need-expert-feedback-on-the-25k-max-line-celling/41605/6 "2022-05-04T21:06:38Z")

</div>

Kindly could you share you methodology with us.  
Thank you

---

<div class="post-metadata">

**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 4, 2022, 9:09pm UTC](https://community.glideapps.com/t/need-expert-feedback-on-the-25k-max-line-celling/41605/7 "2022-05-04T21:09:17Z")

</div>

Holla Alexandrial Yasin
