[DERBY-5698] Document performance issue with 2-arg versions of setXXXStream methods for LOBs

• 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
• Assignee: Camilla Haase
• Reporter: Camilla Haase
• Created: 19/Apr/12 19:25
• Updated: 21/May/12 15:40
• Resolved: 15/May/12 19:18

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.