XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Priority: 4 - Normal
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 6.8.13
    • Component/s: UI, Web UI
    • Labels:

      Description

      Please provide us the ability to externalize the query that loads the ARtifactory tree browser by running a select on all the repositories in the nodes table. We want to add an index to it (sent the index details). Adding this index will load the UI much faster than it performs today.

       

      SELECT COUNT(1) FROM nodes WHERE repo = :1 AND node_path = :2 AND depth = :3

       

      SELECT /*+ index(NODES NODES_REPO_PATH_NAME_IDX) */ COUNT(1) FROM nodes WHERE repo = :1 AND node_path = :2 AND depth = :3

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              shayb Shay Bagants
              Reporter:
              prayyapp Prathibha Ayyappan
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Sync Status

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