MQSeries.net :: View topic

WBI_user

We have a message flow (not developed by us) that performs a loop of SQL selects to an oracle DB and appended the result of each SQL select as the next child to the environment tree. This can results in a very large tree with several thousand children. The developer claim that each result is less than a 100 bytes so it should not take up a lot of memory.
I am not familiar with SQL and Orcale. I like to understand a little more about the result set so that we can plan for the memory usage by the flow.
Will oracle or the broker always trim the results to reduce memory?
For example if the columns are varchar2(200bytes) and only 2 bytes are used, will the result set with 2 columns only contains 4 bytes? When the result set is appended to the environment tree as next child, will that only add 4 bytes to the memory used by the environment tree ? The 200 bytes column and 2 bytes used are just artificial number for the example, there may be reasons for some minimum bytes allocation for the result set buffer or environment tree.