GitHub user partnation opened a pull request:
https://github.com/apache/trafodion/pull/1588
ClipVarchar
When fetching varchar type data from SQL engine, mxosrvr will apply for
enough memory to ensure that the data can be stored, regardless of the actual
varchar length.Then send such a large piece of data to jdbct 4.This results in
unnecessary network overhead and JDBC memory usage.
So I added a function to clip the resulting data. The data to be sent to
JDBCT4 in mxosrvr is trimmed to reduce network overhead and memory
consumption.This function cuts out the redundant parts of varchar type data,
and is very useful for the case where varchar is very long but actually
occupies very little.
I added a switch to jdbct4 code to turn this function on and off according
to the situation.
I tested my code with phx
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/partnation/trafodion clipVarchar
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1588.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1588
----
commit 4ffb07a845940e310fc41f75907e7e5393f0db52
Author: Li Ze <ze.li@...>
Date: 2018-05-31T08:19:57Z
ClipVarchar
----
---
