# Query API updates not adding up **URL:** \ **Category:** Ask for Help\ **Created:** [September 17, 2024, 10:43pm UTC](https://community.glideapps.com/t/query-api-updates-not-adding-up/76457 "2024-09-17T22:43:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [September 17, 2024, 10:43pm UTC](https://community.glideapps.com/t/query-api-updates-not-adding-up/76457/1 "2024-09-17T22:43:42Z")
Our Query API calls seemed very high, so we put in extra logging on our side to figure it out and what we are seeing a 1:4 ration. For every one call we are making Glide is registering 4. We are only using GET (bulk read) API call, on a table that has about 6000 rows. Anyone else doing a bulk GET on a large table and are you seeing a higher number of calls. I am wondering if the size of the table increases the number of updates ? The Glide counter doesn’t update in real time so we cannot do a verfication test. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/2/726b94d3036c885e32663bf56fafee406621e0d8.png) ---
**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:** [September 18, 2024, 12:22am UTC](https://community.glideapps.com/t/query-api-updates-not-adding-up/76457/2 "2024-09-18T00:22:26Z")
So each GET call you do externally would register 4 extra Query API calls? How many rows are you trying to get? > [@Question about updates](https://community.glideapps.com/t/question-about-updates/74853/5): > > Whilst it’s strictly true, “1 update per 10k rows” is misleading in my view. When reading that you could easily be forgiven for thinking you could make 10k API calls, and if each call only returned 1 row then that would be a total of 1 update. But that’s definitely not the case. A better way to put it is “One update per call, and each call will return a maximum of 10k rows”. And yes, the Query API has nothing to do with the Query column. That surprises me. I’d suggest having a close look a… ---
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [September 18, 2024, 12:42am UTC](https://community.glideapps.com/t/query-api-updates-not-adding-up/76457/3 "2024-09-18T00:42:32Z")
Hi Thinh, I read the post and that doesn’t help me answer my question. We have started to keep a full log of all the API Query calls we make, and what we are seeing is about 300 calls per day that we can account for. However we are seeing the Glide API calls counter going up at approximately 1500 per day. We have 6000 rows in our table. We don’t have a detailed log on glide side on how they came up with that number so we are playing bit of a guessing game. I am thinking of taking a backup of the table and truncate it to see if that would make a difference but it does say upto 10k rows and we are below that ---
**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:** [September 18, 2024, 12:52am UTC](https://community.glideapps.com/t/query-api-updates-not-adding-up/76457/4 "2024-09-18T00:52:07Z")
Search for a table called something like “SQL Audit Log”. ![CleanShot 2024-09-18 at 08.48.55@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3c64b119962e3793c7d767eeab1fafd5f4ca768f.jpeg) If you are using Big Tables, this audit log table is automatically generated, and every single action that happens with a Big Table (even Data Editor edits) is logged here. You might be able to use it to help identify where the updates are coming from. ---
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [September 18, 2024, 12:54am UTC](https://community.glideapps.com/t/query-api-updates-not-adding-up/76457/5 "2024-09-18T00:54:10Z")
This is regular glide tables. ---
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [September 20, 2024, 3:28am UTC](https://community.glideapps.com/t/query-api-updates-not-adding-up/76457/6 "2024-09-20T03:28:33Z")
Found the root cause after assistance from support. When using a bulk API query, you are charged 1 update for every 1000 rows. I have 6500 rows so that was 7 updates for each API call I was making. The 10k limit is that you can get a max of 10,000 rows returned in a single response, but that will cost you 10 updates. I had bad code on my side that was making about 250-300 calls per day, and also I was being lazy and not deleting the rows, so an expensive lesson 🙂 ---
**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:** [September 20, 2024, 11:49am UTC](https://community.glideapps.com/t/query-api-updates-not-adding-up/76457/7 "2024-09-20T11:49:02Z")
Thanks for sharing.