Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-1377

Faster client-side query parsing in ClientParser and NativeSql

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0
    • performance
    • None

    Description

      Client-side prepared statements parse the SQL on every prepareStatement (text protocol) to locate
      parameter markers, strings, comments and INSERT ... VALUES / ON DUPLICATE keywords, and
      Connection.nativeSQL / escape processing lexes the text again to resolve

      {fn ...}, {ts ...} 
      

      escapes.

      Both lexers were byte-at-a-time state machines doing several comparisons per byte. They are rewritten
      to skip ordinary bytes through a 256-entry lookup table and to consume strings, backtick identifiers
      and comments in tight inner loops, with the same results as before (same unit test corpus).

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            diego dupin Diego Dupin
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.