Data Size of Query

Question

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.

Stefan Helzle · Answer

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?

Soma · Answer

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.

Abhishek Karumuru · Answer

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