Uploaded image for project: 'Groovy'
  1. Groovy
  2. GROOVY-9676

getParameterMetaData calls result in extra network roundtrip per row

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.0.3
    • None
    • SQL processing
    • None

    Description

      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.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            Mike_M Mike_M

            Dates

              Created:
              Updated:

              Slack

                Issue deployment