[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


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 Jul 02 10:34:23 UTC 2020 using Jira 8.5.3#805003-sha1:b4933e02eaff29a49114274fe59e1f99d9d963d7.