Derby
  1. Derby
  2. DERBY-5698

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

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major 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.

      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:
            Kim Haase
            Reporter:
            Kim Haase
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development