[RTFACT-13822] Most downloaded widget in Artifactory home can cause the DB to stall Created: 01/Mar/17  Updated: 19/Dec/17  Resolved: 02/Mar/17

Status: Resolved
Project: Artifactory Binary Repository
Component/s: Home Page, Performance
Affects Version/s: 5.0.0, 5.0.1.1, 5.0.1, 5.1.0
Fix Version/s: 5.1.2

Type: Bug Priority: Critical
Reporter: Yinon Avraham Assignee: Yinon Avraham
Resolution: Fixed Votes: 0
Labels: None


 Description   

Every time the home page is refreshed or just the "Most Downloaded" widget is refresh, the application performs an AQL that joins both the nodes and stats tables and yields a full scan of the result. In large instances, with many items, concurrent requests due to logins and home page refreshes can increase the load on the DB and cause it to stall.


Generated at Tue Sep 22 18:59:08 UTC 2020 using Jira 8.5.3#805003-sha1:b4933e02eaff29a49114274fe59e1f99d9d963d7.