Uploaded image for project: 'Gazelle Security Suite'
  1. Gazelle Security Suite
  2. GSS-375

Create missing index in DB to improve search performance

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.2.1
    • Fix Version/s: 5.3.1
    • Component/s: None
    • Labels:
      None
    • Account:
      Maintenance 2016 (MAINTENANCE2016)

      Description

      We need to add the following index in the database

      CREATE INDEX tls_certificate_subject_index ON tls_certificate(subject);

      I have created it on the ovh3 server and search of certificates in the page https://gazelle.ihe.net/gss/certificate/list.seam is now faster

      I do not have the sources of the application on my machine to add the change directyl. Thanks for doing it.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ceoche Cédric EOCHE-DUVAL
                Reporter:
                epoiseau Eric Poiseau
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2 hours Original Estimate - 2 hours
                  2h
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days, 4 hours
                  2d 4h

                    Potential Duplicates