Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-3096

clip the varchar type data from mxosrvr to jdbct4

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                LiZe LiZe
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: