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)

Reply via email to