[CAY-1923] Optimize BatchTranslator - use fixed size array of BatchParameterBinding

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.M2
• Assignee: Andrus Adamchik
• Reporter: Andrus Adamchik
• Created: 27/Mar/14 07:52
• Updated: 27/Mar/14 14:30
• Resolved: 27/Mar/14 14:30

Description

The new BatchTranslator has this method:

List<BatchParameterBinding> createBindings(BatchQueryRow row);

The list contents differ from row to row (e.g. due to NULL handling). This means we need to create a new List and new BatchParameterBindings, which results in an inefficiency in the default mode of operation. This also makes crypto-related interception doubly inefficient, as we'll need to compile encryptors for each row individually. So need to batch this somehow. E.g. by allocating a single BatchParameterBinding[], filling it with bindings and then reusing it for each row. Excluded bindings for a given row will be marked with some flag. This will also allow to precompile encryptors in the crypto module.