Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5698

Document performance issue with 2-arg versions of setXXXStream methods for LOBs

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.8.2.2
    • Fix Version/s: 10.9.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      The PreparedStatement.setAsciiStream and other methods have a 3-arg form that includes the length of the stream and a 2-arg form that does not. If the 2-arg form is used, Derby has to calculate the length every time the method is called. With LOBs, especially large ones, this can cause a major performance impact, especially if the method is called repeatedly. This should be documented where appropriate.

      Kristian, please feel free to correct or amplify anything I've said here.

        Attachments

        1. DERBY-5698-3.zip
          6 kB
          Kim Haase
        2. DERBY-5698-3.diff
          4 kB
          Kim Haase
        3. DERBY-5698-2.zip
          6 kB
          Kim Haase
        4. DERBY-5698-2.diff
          4 kB
          Kim Haase
        5. DERBY-5698.zip
          6 kB
          Kim Haase
        6. DERBY-5698.stat
          0.1 kB
          Kim Haase
        7. DERBY-5698.diff
          3 kB
          Kim Haase

          Activity

            People

            • Assignee:
              chaase3 Kim Haase
              Reporter:
              chaase3 Kim Haase
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: