Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-120

slow performance on querys with large number of result rows

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.0.2
    • 2.0.16, 3.0.3
    • General
    • None
    • centos7 with ColumnStore 1.1 or Server 10.2.9

    Description

      There appears to be a significant overhead in query and returning results when using ODBC. I can reproduce this on both windows and unix but using unix here.

      Create the following orders table:

      create table orders (
              o_orderkey bigint,
              o_custkey int,
              o_orderstatus char (1),
              o_totalprice decimal(12,2),
              o_orderdate date,
              o_orderpriority char (15),
              o_clerk char (15),
              o_shippriority int,
              o_comment varchar (79)
      ) ;
       
      load data local infile 'orders50k.tbl' into table orders;
      

      test data attached gzipped

      In my case using a separate VM as the ODBC client host.

      Using isql piped to /dev/null:

      # time echo "select * from orders" | isql centos > /dev/null
       
      real    0m3.553s
      user    0m3.484s
      sys     0m0.010s
      

      using same with mysql odbc:

      # time echo "select * from orders" | isql mycentos > /dev/null
       
      real    0m0.767s
      user    0m0.728s
      sys     0m0.007s
      

      with mysql client:

      # time mysql -u root -h 172.21.21.6 -vvv test -e "select * from orders" > /dev/null
       
      real    0m0.122s
      user    0m0.081s
      sys     0m0.006s
      

      I can understand some overhead of ODBC but ours seem large and is not as good as mysql community driver performance?

      Config:

      # cat /etc/odbcinst.ini
      [mariadb]
      Description=Maria DB
      Driver64=/usr/lib64/libmaodbc.so
       
      [MySQL]
      Description     = ODBC for MySQL
      Driver64        = /usr/lib64/libmyodbc5.so
       
       
      # cat /etc/odbc.ini
      [centos]
      Driver=mariadb
      Server=172.21.21.6
      Database=test
      Port=3306
      User=root
      Password=
       
      [mycentos]
      Driver=MySQL
      Server=172.21.21.6
      Database=test
      Port=3306
      User=root
      Password=
      

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            dthompson David Thompson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.