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

            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