[DERBY-212] Optimize some specific methods in Network Server to improve performance

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.1.1.0
• Fix Version/s: 10.3.1.4
• Component/s: Network Server
• Bug behavior facts: Performance
• Assignee: Dyre Tjeldvoll
• Reporter: Katherine Marsden
• Created: 11/Apr/05 10:35
• Updated: 21/Jan/11 18:13
• Resolved: 25/Oct/06 12:35

Description

In reviewing the Network Server Code and profiling there were
several areas that showed potential for providing performance
improvement.

Functions that need optimizing to prevent unneeded object
creation and excessive decoding
parsePKGNAMCSN()
parseSQLDTA_work()
buildDB2CursorName()

In DDMWriter and DDMReader, use System Routines in
java.util.Arrays and System.arrayCopy instead of
writing code to do functions like copy arrays and
pad strings.

Sub-Tasks

• Prevent unneeded object creation and excessive decoding in parsePKGNAMCSN(): Closed
• Prevent unneeded object creation and excessive decoding in parseSQLDTA_work(): Closed
• In DDMWriter and DDMReader, use system routines in java.util.Arrays and System.arrayCopy: Closed
• Minor patches to client/net/(Reply|Request).java to use System.arrayCopy and java.util.Arrays: Closed
• writeSQLCAGRP() should use byte[] constants instead of Strings where feasible: Closed