[RTFACT-14888] Improve node with properties search by optimizing the indices in node_props Created: 03/Sep/17  Updated: 05/Dec/17  Resolved: 05/Dec/17

Status: Resolved
Project: Artifactory Binary Repository
Component/s: Database, Properties
Affects Version/s: None
Fix Version/s: 5.7.0

Type: Bug Priority: Normal
Reporter: Nadav Yogev Assignee: Tomer Mayost (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
relates to RTFACT-14929 Add a new text pattern index for the ... Open
Assigned QA: Tamir Hadad
Epic Link: Q4 Customer Commitments Leap 24
Sprint: Leap 20, Leap 23, Leap 25, Leap 26


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.

Comment by Tomer Mayost (Inactive) [ 23/Nov/17 ]

QA: need to run the query and check performance on a large scale db (postgres). i checked with 3000 artifacts. its not enough.

Generated at Thu Dec 12 04:31:21 UTC 2019 using JIRA 7.6.16#76018-sha1:9ed376192612a49536ac834c64177a0fed6290f5.