You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@groovy.apache.org by "Mike_M (Jira)" <ji...@apache.org> on 2020/08/07 05:28:00 UTC

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

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)