Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-4721

Performance issue with version of H2 that we are using

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: TBD
    • Resolution: Fixed
    • Affects Version/s: Platform 1.10.2, Platform 1.11.3, Platform 1.12.0, Platform 1.13.0
    • Component/s: None
    • Labels:
      None
    • Complexity:
      Low

      Description

      We recently upgraded to version 1.4.183 of H2.

      We were noticing some performance problems in our tests, and discovered that 1.4.183 is a beta release, with the following issue:

      • indexes were not used if the table contains columns with a default value generated by a sequence. This includes tables with identity and auto-increment columns. This bug was introduced by supporting "rownum" in views and derived tables.

      We should switch and use the most stable release of H2

        Gliffy Diagrams

          Attachments

            Activity

              People

              Assignee:
              mogoodrich Mark Goodrich
              Reporter:
              mogoodrich Mark Goodrich
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: