Mike_M created GROOVY-9676:
------------------------------
Summary: getParameterMetaData calls result in extra network
roundtrip per row
Key: GROOVY-9676
URL: https://issues.apache.org/jira/browse/GROOVY-9676
Project: Groovy
Issue Type: Bug
Components: SQL processing
Affects Versions: 3.0.3
Reporter: Mike_M
Attachments: batch.pdf
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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)