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?
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