Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6841

Derby v10.12.1.1 is horribly slow compared to v10.11.1.1 in embedded mode

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not A Problem
    • Affects Version/s: 10.12.1.1
    • Fix Version/s: 10.11.1.1
    • Component/s: JDBC, SQL
    • Labels:
      None
    • Environment:
      OS: Windows, OS X, Linux
      CPU: Quad-Core Intel i5
      App: Swing, multi-threaded
    • Urgency:
      Normal
    • Bug behavior facts:
      Performance, Regression, Seen in production
    • Flags:
      Important

      Description

      It takes much longer to open, read, and close embedded databases using v10.12.1.1 than it did with v10.11.1.1. What ever changes you guys made over the last year and a bit have definitely been for the worse.

      Below are the results of the repetition tests I've just run on the same computer with the same databases. Let me know if you need to know about the sizes of the databases and/or the file type they contain.

      Connecting with v10.11.1.1:
      Database opened in 0.82 seconds.
      Database opened in 0.77 seconds.
      Database opened in 0.88 seconds.
      Database opened in 0.77 seconds.
      Database opened in 0.77 seconds.
      Database opened in 0.96 seconds.
      Database opened in 0.74 seconds.

      Connecting with v10.12.1.1:
      Database opened in 1.98 seconds.
      Database opened in 2.07 seconds.
      Database opened in 1.97 seconds.
      Database opened in 2.01 seconds.
      Database opened in 2.01 seconds.
      Database opened in 2.00 seconds.
      Database opened in 2.03 seconds.

      Reading with v10.11.1.1:
      Database processed in 6.17 seconds.
      Database processed in 4.00 seconds.
      Database processed in 3.67 seconds.
      Database processed in 3.66 seconds.
      Database processed in 3.78 seconds.
      Database processed in 3.69 seconds.
      Database processed in 3.74 seconds.

      Reading with v10.12.1.1:
      Database processed in 7.29 seconds.
      Database processed in 4.54 seconds.
      Database processed in 4.88 seconds.
      Database processed in 4.65 seconds.
      Database processed in 4.34 seconds.
      Database processed in 4.35 seconds.
      Database processed in 4.50 seconds.

      Disconnecting with v10.11.1.1:
      Database closed in 0.11 seconds.
      Database closed in 0.13 seconds.
      Database closed in 0.15 seconds.
      Database closed in 0.14 seconds.
      Database closed in 0.10 seconds.
      Database closed in 0.13 seconds.
      Database closed in 0.14 seconds.

      Disconnecting with v10.12.1.1:
      Database closed in 0.74 seconds.
      Database closed in 0.87 seconds.
      Database closed in 0.76 seconds.
      Database closed in 0.87 seconds.
      Database closed in 0.85 seconds.
      Database closed in 0.69 seconds.
      Database closed in 0.84 seconds.

        Attachments

        1. 10.11.1.1.txt
          3 kB
          Xavion
        2. 10.12.1.1-Fresh.txt
          3 kB
          Xavion
        3. 10.12.1.1-Hard.txt
          3 kB
          Xavion
        4. 10.12.1.1-Soft.txt
          3 kB
          Xavion
        5. DERBY_6841.java
          5 kB
          Richard N. Hillegas

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Xavion Xavion
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: