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: High
    • Resolution: Fixed
    • Affects Version/s: 5.2.1
    • Fix Version/s: 5.3.1
    • Component/s: None
    • Labels:
      None
    • Sprint:
      2016 - S12, 2016 - S13, 2016 - S14
    • Account:
      Maintenance 2016 (MAINTENANCE2016)
    • Story Points:
      1

      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.

        BigPicture - Work Breakdown Structure

          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

                  BigPicture - Skills

                    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