[
https://issues.apache.org/jira/browse/GROOVY-9676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17172931#comment-17172931
]
Mike_M commented on GROOVY-9676:
--------------------------------
[~paulk]thanks for the rapid response. Unfortunately, my skills are limited to
the Groovy scripting level. Happy to assist in testing though.
> 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)
