LiZe created TRAFODION-3096:
-------------------------------
Summary: clip the varchar type data from mxosrvr to jdbct4
Key: TRAFODION-3096
URL: https://issues.apache.org/jira/browse/TRAFODION-3096
Project: Apache Trafodion
Issue Type: New Feature
Components: client-jdbc-t4, connectivity-mxosrvr
Reporter: LiZe
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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)