Uploaded image for project: 'perf-testing'
  1. perf-testing
  2. PERF-76

Run performance tests following addition of Index for Instances Full-text Subjects Search

    XMLWordPrintable

Details

    • CP: sprint 91
    • 1

    Description

      Overview:
      Currently doing an Instance subject search by any keyword in an environment that has over 1.5 million instances records takes more than 80 seconds to return. mod-inventory-storage log shows a warning for missing full-text index. When applying a subjects full text index to the {tenant}_mod_inventory_storage.instance table the response time improved dramatically to under 2 seconds.

      Steps to Reproduce:

      • Navigate to Inventory app
      • On the left "Search & Filter", make sure "Instance" is selected
      • Click on the first drop down to select "Subject" search option
      • Enter a keyword to search.
      • * Note that in a database with more than 1 million records it will take more than a minute for results to return.

      Acceptance criteria:

      1. UI search using the search option: Subjects takes less than 2 sec.

      Attachments

        Issue Links

          Activity

            People

              mtraneis Martin Tran
              mtraneis Martin Tran
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: