[
https://issues.apache.org/jira/browse/GROOVY-9676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17173098#comment-17173098
]
Mike_M commented on GROOVY-9676:
--------------------------------
Applied this change to script test4.groovy (see attachment).
Before the change: 167 ms per row (batch size doesn't really make a difference)
After the change:
9 ms per row (batch size 20)
5 ms per row (batch size 50)
> 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)
