Advice on how to measure query data size while using DB2?

jayashrib223 over 7 years ago

Hi,

In Appian we have 1 MB limit for any DB query result set so how to determine the size of Query Entity result set?
We are using DB2 database and not able to find any way to measure the resultant data size.

Thanks,
Jayashri

Discussion posts and replies are publicly visible

Parents

0 ChristineH
Certified Lead Developer
over 7 years ago

I'm not familiar with DB2 tools, but in sql you can access client statistics to see this. May want to google what exists in db2.

Also, it may be less about what the full query is and instead make sure that you are bringing back consumable amounts of data in your paging size (instead of bringing all rows back), only the fields the user needs or wants to see, etc. This will help make sure you don't exceed the limit.

Hope that helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ChristineH
Certified Lead Developer
over 7 years ago

I'm not familiar with DB2 tools, but in sql you can access client statistics to see this. May want to google what exists in db2.

Also, it may be less about what the full query is and instead make sure that you are bringing back consumable amounts of data in your paging size (instead of bringing all rows back), only the fields the user needs or wants to see, etc. This will help make sure you don't exceed the limit.

Hope that helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data