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

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      mariadb in ubuntu

      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

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

              Dates

              Created:
              Updated: