[
https://issues.apache.org/jira/browse/GROOVY-9676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17172905#comment-17172905
]
Paul King commented on GROOVY-9676:
-----------------------------------
That looks like a comprehensive analysis. We'll take some time to absorb it.
You could try your own experiment in the meantime. Create your own extension of
the groovy.sql.Sql class and override the setParameters method replacing it
with just the first and last three lines in the existing method.
> 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
> Priority: Major
> 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)
