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

          Details

          • Type: Bug
          • Status: Resolved
          • Priority: Normal
          • Resolution: Fixed
          • Affects Version/s: None
          • Fix Version/s: 5.7.0
          • Component/s: Database, Properties
          • Labels:
            None

            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

                • Normal - Major loss of function.
                • Open

                  Activity

                    People

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

                      Dates

                      • Created:
                        Updated:
                        Resolved: