[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. |