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

        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: