Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-14888

Improve node with properties search by optimizing the indices in node_props

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 5.7.0
    • Component/s: Database, Properties
    • Labels:
      None
    • Severity:
      Medium

      Description

      Improve AQL queries performance when searching artifacts of a certain build name and number
      Replacing the existing in 3 indices node_props - on node_id, prop_key and on prop_value.

        Attachments

          Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task RTFACT-14929 Add a new text pattern index for the nodes table for the Quick Search queries

          • Open

            Activity

                People

                Assignee:
                tomerma Tomer Mayost (Inactive)
                Reporter:
                nadavy Nadav Yogev
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Sync Status

                    Connection: RTFACT Sync
                    RTMID-14888 -
                    SYNCHRONIZED
                    • Last Sync Date: