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

Slow build properties retrieval SQL query

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Resolution: Done
    • Affects Version/s: 4.13.2
    • Fix Version/s: 5.6.0
    • Component/s: Build Info, Properties
    • Labels:
      None

      Description

      Under a large scale build info's recorded on the DB and build annotated properties (hundreds of thousands of properties), the issued DB query below (issued by Artifactory when navigating to the Builds tab on the UI)

      "SELECT distinct build_props.prop_key propsKey,build_props.prop_value propsValue from  build_props\n" +
                  "  inner join\n" +
                  "  builds on builds.build_id = build_props.build_id where builds.build_number = ?\n" +
                  "                                                         and builds.build_date = ?\n" +
                  "                                                         and build_props.prop_key not in (  SELECT distinct build_props.prop_key from  build_props inner join\n" +
                  "                                                                                            builds on builds.build_id = build_props.build_id where builds.build_number = ?\n" +
                  "                                                                                            and builds.build_date = ?\n" +
                  "                                                                                            and build_props.prop_key like 'buildInfo.env.%' )\n";
      

        Attachments

          Activity

            People

            Assignee:
            saffih Saffi Hartal [X] (Inactive)
            Reporter:
            andreik Andrei Komarov [X] (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: