[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: |
|
||||||||
Assigned QA: | Tamir Hadad | ||||||||
Epic Link: | Q4 Customer Commitments Leap 24 | ||||||||
Sprint: | Leap 20, Leap 23, Leap 25, Leap 26 |
Description |
Improve AQL queries performance when searching artifacts of a certain build name and number |
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. |