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

Improve the performance of connections to soft-upgraded databases

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.12.1.1
    • Fix Version/s: None
    • Component/s: Documentation, JDBC, SQL
    • Labels:
      None
    • Environment:
      N/A
    • Urgency:
      Normal
    • Bug behavior facts:
      Performance, Seen in production

      Description

      As discovered in Issue #6841, connections to soft-upgraded databases are significantly slower than those to their hard-upgraded counterparts. To get an idea of just how severe the performance loss is in the former case, take a look at the results of the repetition tests run by myself (Xavion) and Rick Hillegas.

      In the meantime, I noticed that there doesn't seem to be any mention in Derby's documentation about the loss of performance experienced when using soft-upgraded databases. The only thing anyone seems to care about is the loss of functionality that one can expect when using an older database.

      In fact, the "Soft upgrade limitations" article doesn't even exist anymore in Derby releases above v10.9. Given how old (and therefore mature) Derby is, people like myself assume that its database format doesn't change much between versions. Due to this, it'd never occur to us that soft-upgrading could be so detrimental to performance.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: