[jira] [Commented] (GROOVY-9676) getParameterMetaData calls result in extra network roundtrip per row

["Paul King (Jira)" <ji...@apache.org>]

    [ 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)