Question

Data Size of Query

Forum|Forum|1 year ago
October 22, 2024
9 replies
0 views

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.

B

bajib0001

Hi [mention:b08a9915dde2428e9c6dfef8cba0cdd6:e9ed411860ed4f2ba0265705b8793d05]

The default is 1048576 bytes (1 MB). Before changing this value, consider using the query rules paging parameter to return less data (or return data in batches) and therefore avoid the limit. Also, consider whether the entire set of data that is being returned is actually needed. If not, use the query expression functions to select which fields to return.

sarathkumr268295Author

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.

stefanhelzle0001

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?

somasundaram.d

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.

sarathkumr268295Author

Thanks [mention:57fc948ec4c44d7fbda6e5509555d197:e9ed411860ed4f2ba0265705b8793d05] , will try it

karumurua531442

Hi [mention:b08a9915dde2428e9c6dfef8cba0cdd6:e9ed411860ed4f2ba0265705b8793d05] 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

shaikhm2967

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.

sarathkumr268295Author

Thank you for your reply

Sign up

Login with SSO

Login to the community

Login with SSO