Uploaded image for project: 'EJBCA'
  1. EJBCA
  2. ECA-7607

Optimize ejbca-db-cli speed when verifying audit log

        Details

        • Type: Improvement
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: EJBCA 6.15.1
        • Fix Version/s: EJBCA 7.0.1
        • Component/s: None
        • Labels:
          None
        • Provenance:
          Internal Delivery
        • Issue discovered during:
          Customer
        • Sprint:
          EJBCA Team Alice - 2019 w6

          Description

          There are two issues with the "ejbca-db-cli.jar verify" command, here and ECA-7609

          1. See ECA-7609.
          2. The verify is extremely slow on a large dataset. If you had million records in the table, it could take days. Improving DB query in "IntegrityProtectedAuditReader.java” fixes this. This speeds up verify considerably.

           

            Attachments

              Issue Links

              is cloned by

              Improvement - An improvement or enhancement to an existing feature or task. ECA-7609 Clear hibernate cache in ejbca-db-cli to avoid high memory usage

              • Major - Major loss of function.
              • Closed

                Activity

                  People

                  • Assignee:
                    tomas Tomas Gustavsson
                    Reporter:
                    tomas Tomas Gustavsson
                    Verified by:
                    Johan Eklund
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - 4 hours
                      4h
                      Remaining:
                      Time Spent - 2 hours Remaining Estimate - 2 hours
                      2h
                      Logged:
                      Time Spent - 2 hours Remaining Estimate - 2 hours
                      2h