Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-23293

Stored procedure having just one plain insert stmt takes 10 times longer that executing same insert directly

    XMLWordPrintable

Details

    Description

      I have created a stored procedure which has just one insert statement to a table which takes 10 times longer to execute as compared to sending the exact same insert statement executed using mariadb client.

      I am calling the stored procedure from a python program. Tested the same insert SQL directly executing from python program.

      It takes one second to do 50 inserts (row) by calling stored procedure each time
      It takes one second to do 500 inserts (no stored procedure call) by executing insert SQL stmt each time

      Attachments

        Activity

          People

            Unassigned Unassigned
            shamim.ahmad@nttdata.com Shamim
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.