Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-389

Totalnum performance improvements

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.12
    • 1.7.13, 1.7.12a
    • None
    • None

    Description

      Totalnum counter performance is unacceptable on very large (>1.5million) element ontologies such as the ACT Medications ontology. Even smaller but very deep ontologies fail to compute on MSSQL and Oracle. Also, we plan to add some additional debug messages.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          jklann Jeffrey Klann added a comment -
          1.7.12a has performance improvements in Postgres and MSSQL. Oracle improvements still forthcoming.
          jklann Jeffrey Klann added a comment - 1.7.12a has performance improvements in Postgres and MSSQL. Oracle improvements still forthcoming.
          jklann Jeffrey Klann added a comment -
          Oracle, PGSQL, and MSSQL are all now on par with performance. MSSQL's most recent improvement, contributed by Darren Henderson, does not make sense in the architecture of the other scripts (it doesn't generate the same temp table).

          This could be reopened in the future, as performance can always be improved.
          jklann Jeffrey Klann added a comment - Oracle, PGSQL, and MSSQL are all now on par with performance. MSSQL's most recent improvement, contributed by Darren Henderson, does not make sense in the architecture of the other scripts (it doesn't generate the same temp table). This could be reopened in the future, as performance can always be improved.
          rm302 Reeta Metta added a comment -
          oracle script errors out on
          rm302 Reeta Metta added a comment - oracle script errors out on

          People

            jklann Jeffrey Klann
            jklann Jeffrey Klann
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: