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

        1. eca-7607-trunk.patch
          6 kB
          Tomas Gustavsson
        2. IntegrityProtectedAuditReader.java
          12 kB
          Tomas Gustavsson

          Issue Links

            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