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

find from access in a varchar column is so slow ms access freezing for minutes in a small table.

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Stalled (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.0.6
    • Fix Version/s: 3.1
    • Component/s: General
    • Labels:
      None
    • Environment:
      Windows, MS Access

      Description

      from ms access.
      the find in a table in a varchar column is so slow MS Access freezing for minutes.
      it also prevents the use of access functions like find go to find the first occurrence of something.

      also, there is another thing when tracing odbc , it says invalid length -1. many times sometimes.

      how to reproduce:
      create an InnoDB table in the server, with columns of: id int auto_increment and varchar(256)

      CREATE TABLE `test` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `text` varchar(256) DEFAULT NULL,
      PRIMARY KEY (`id`)
      ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

      /* copy paste about 1000 times (select this line and next emmpty line and press control+c and hold control+v until there is enough line number): */
      INSERT INTO `test`(`text`)VALUES(RAND());

      SELECT * FROM test;

      create empty ms access file.
      open odbc32 in windows, make a connection to the server and call it with some name, using MariaDB driver. (although I connect SSL i believe it does not change anything, also I connect to database on the internet on my server. so there is some latency)
      add from: external data>new data source>from other sources>odbc database. choose: link to the data source. select tab machine data source. pick the table.

      open the table in ms access and select the column with the text and press control+f. type something and click find. see it takes a long time. in a not very long table (i use MS Access 2013)

        Attachments

          Activity

            People

            Assignee:
            Lawrin Lawrin Novitsky
            Reporter:
            shimondoodkin Shimon Doodkin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration