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

Improve execute direct (prepare and execute) performance

    Details

      Description

      Sequence of prepare and then executing require a lot of double work it looks like this:
      Prepare:
      1.1 Parse
      1.2 open and lock tables
      1.3 prepare
      1.4 close tables
      1.5 cleanup
      Execute:
      2.1 open and lock tables
      2.2 prepare
      2.3 optimize
      2.4 execute
      2.5 close tables
      2.6 cleanup

      It is clear, that if we would know that it is direct execute call we can avoid double work on the server side

        Attachments

          Activity

            People

            • Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              sanja Oleksandr Byelkin
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: