# API and Row Owner **URL:** \ **Category:** Ask for Help\ **Created:** [December 3, 2023, 10:36am UTC](https://community.glideapps.com/t/api-and-row-owner/68321 "2023-12-03T10:36:18Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [December 3, 2023, 10:36am UTC](https://community.glideapps.com/t/api-and-row-owner/68321/1 "2023-12-03T10:36:18Z")
Hi community! I’m working an app for little delivery company. I would ask about performances(power) of Glide API endpoint and Row Owner function. I have Order table and Order’s goods table Order’s goods table have 1000 add row a day. So, the best way to deal with this is integration to SQL server but, starting cost (minimal Glide Enterprise contract), just to develop is around 6000$. I can’t ask customer this price without working prototype and investment from me like a developer is too high. A imagine temporary solution is: - to develop prototype on Glide table as mostly flexible for development purposes and fastest and off course cheapest. Every 20 day i will do move data from both tables to Glide Big table or to GS. But i remember many users has reported some performances issues after 4000…10000(or after 20000) rows per app. In this case i want to implement Row owner function to reduce the data loaded to user’s devices. And i want dynamically set the value of the Row owned columns and rows by API call Why by API? Because i need to change not only Order row also related goods multiple rows. May be so many row owned column changes (at list 1000 or more changes) per day, does it will reduce the performance of the app more than in case 20000…25000 rows per app? The Role column of the user is fixed and didn’t changing. Am afraid to use Glide Big Table as a main DB, because users will need to manually reload newest data. If someone have some ideas or practical cases i would like to study it. Also, i afraid to store goods in an array or as JSON text field, because is to hart to develop during so many changes and new flows (task routes) Many thanks, Alexey! ---
**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:** [December 3, 2023, 11:37pm UTC](https://community.glideapps.com/t/api-and-row-owner/68321/2 "2023-12-03T23:37:49Z")
> [@slscustom.ru](#): > > Am afraid to use Glide Big Table as a main DB, because users will need to manually reload newest data. You have a Reload Query action that can help in your flow so users won’t have to manually do it. > [@slscustom.ru](#): > > And i want dynamically set the value of the Row owned columns and rows by API call Wouldn’t this also consume a huge chunk of your updates? ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [December 3, 2023, 11:53pm UTC](https://community.glideapps.com/t/api-and-row-owner/68321/3 "2023-12-03T23:53:18Z")
Hello, ThinhDinh! Thanks for income! I imagine we will have much more than 25000 updates per month may be much more. And this is accepted and can be imagined how much, but Reload Query before each entering to details screen gives unknown scale of updates. And i must to force users to doing something, just to be updated (not so good). ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 3, 2023, 11:56pm UTC](https://community.glideapps.com/t/api-and-row-owner/68321/4 "2023-12-03T23:56:20Z")
turn your data to JSON files, and use Javascript column to operate it. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [December 4, 2023, 12:10am UTC](https://community.glideapps.com/t/api-and-row-owner/68321/5 "2023-12-04T00:10:29Z")
Hello, Uzo! Thanks for income! All my time i trying to do not use JS until it possible. Do you remember fetch column? It’s gone. JS also in Experimental tab. May be i need to follow your suggestion… I don’t know… I remember David talked about some customer’s case i which they deal with 800 active users a day for warehouse company. I will deal with 80. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 4, 2023, 12:15am UTC](https://community.glideapps.com/t/api-and-row-owner/68321/6 "2023-12-04T00:15:28Z")
Since when is it gone? I just used it a few hours ago… 800 users? lol… that’s nothing… ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [December 4, 2023, 12:17am UTC](https://community.glideapps.com/t/api-and-row-owner/68321/7 "2023-12-04T00:17:56Z")
> [@ThinhDinh](#): > > Wouldn’t this also consume a huge chunk of your updates? I remember API Call cost 1 update, but 500 of table mutations ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 4, 2023, 12:18am UTC](https://community.glideapps.com/t/api-and-row-owner/68321/8 "2023-12-04T00:18:32Z")
Don’t use API… use fetch JSON… ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [December 4, 2023, 12:24am UTC](https://community.glideapps.com/t/api-and-row-owner/68321/9 "2023-12-04T00:24:13Z")
Yes, i remember your fantastic case. But there so much things for power programmer like you! But i need much more no-code solution. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 4, 2023, 12:26am UTC](https://community.glideapps.com/t/api-and-row-owner/68321/10 "2023-12-04T00:26:33Z")
I understand… then you have to upgrade your plan to enterprise. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [December 4, 2023, 12:28am UTC](https://community.glideapps.com/t/api-and-row-owner/68321/11 "2023-12-04T00:28:17Z")
Of course, but I have to start with a business ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 4, 2023, 12:30am UTC](https://community.glideapps.com/t/api-and-row-owner/68321/12 "2023-12-04T00:30:32Z")
you need to figure out what is your usage, and choose the right plan… if that will not be good, you can always hire me to fix your App. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [December 4, 2023, 12:40am UTC](https://community.glideapps.com/t/api-and-row-owner/68321/13 "2023-12-04T00:40:32Z")
Yea, I every time talking customers about Uzo, who making magic not waiting from Glide! But they told me: “Listen, Uzo maybe great, but his on another side of earth, let’s do it yourself. Take our money and try” 🙂 Really 🙂 ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 4, 2023, 12:42am UTC](https://community.glideapps.com/t/api-and-row-owner/68321/14 "2023-12-04T00:42:39Z")
Hahahah… I can save you years of trying and tons of money 😉