Derby
  1. Derby
  2. DERBY-5980

Extremely slow roll forward when booting database that wasn't properly closed

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 10.9.1.0
    • Fix Version/s: None
    • Component/s: Store
    • Labels:
      None
    • Environment:
      Windows 7, Embedded mode
    • Bug behavior facts:
      Performance

      Description

      Reproduction sequence:
      1. Open database in embedded mode
      2. Run a considerably large transaction - for example, one that creates 10 - 20 MB of db logs
      3. Commit
      4. Do NOT close the Connection
      5. Exit the application (through System.exit() for example)
      6. Restart the application and open the database

      Observed:
      Opening connection is extremely slow. It takes up 30- 60 seconds on the 10-20 MB transaction, and for larger transactions it takes forever.

      Looking at the process with FileMon utility, I can see that redo log files are mostly read 1 byte at a time.
      I bet you can improve the performance 100-fold by getting the whole log into memory first.

        Activity

        Hide
        Mike Matrigali added a comment -

        posting an exact repro case would make it more likely the community would help with this. It helps to make sure
        what you are seeing is what others are seeing. For instance there is a big difference between 10-20 MB of 1 byte
        inserts vs 1 20 mb blob insert.

        Show
        Mike Matrigali added a comment - posting an exact repro case would make it more likely the community would help with this. It helps to make sure what you are seeing is what others are seeing. For instance there is a big difference between 10-20 MB of 1 byte inserts vs 1 20 mb blob insert.

          People

          • Assignee:
            Unassigned
            Reporter:
            Igor Sereda
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:

              Development