Is there any to find the size of the data that is returned by a query?? The default size limit is 1MB, but we want to understand how much rows we can pull from database without reaching this limit.
Discussion posts and replies are publicly visible
Hi Sarathkumar R
We are not trying to change the limit. We just want to know if we can figure out the size somehow so we can understand how many rows we can query from database.
I think there is now way to directly get this number. You could try to add up the fields lengths in your record to get a rough idea.
My question is, what is the purpose of this exercise? Do you try to somehow optimize some queries to get as much data as possible?
You cannot get exact row limit, but you can try exporting the table values in an excel sheet. Then try removing the rows and check the size of the excel sheet. When the size of excel is around 1 MB, you can take the number of rows, verify the same by marginally changing the number and passing it as batch size in the query.
We have to expose an API which will be used to query data by external system. We just want to understand how much rows we can send without reaching the limit since we might send large number of data depending on the scenario and optimize or redesign the flow to send data without any issues
Thanks Soma , will try it
Hi Sarathkumar R there no specific number that we can think of, it always varies from one scenario to other because we use different type of data types for our application. We use different type of fields, columns for our applications. It is hard to know the number/ count of rows
In Appian, there isn't a direct way to determine the exact size of data returned by a query without experimenting, but you can estimate it by considering the average row size in bytes and calculating the number of rows that would approximately fit within the 1MB limit.
Thank you for your reply