[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:
Relationship
relates to RTFACT-14929 Add a new text pattern index for the ... Open
Assigned QA: Tamir Hadad

 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.

 Comments   
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 Sep 19 02:49:39 UTC 2019 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.