[GROOVY-9676] getParameterMetaData calls result in extra network roundtrip per row

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.3
• Component/s: SQL processing
• Assignee: Unassigned
• Reporter: Mike_M
• Created: 07/Aug/20 05:27
• Updated: 07/Aug/20 11:44

Description

When using a prepared statement, GroovySql calls getParameterMetaData wich requires a network roundtrip.

The impact is:

• Prepared statements are slower than non-prepared statements
• Batch inserts are slower than row-by-row inserts

See test cases and measurements in attachment.