[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
|Project:||Artifactory Binary Repository|
|Component/s:||Home Page, Performance|
|Affects Version/s:||5.0.0, 18.104.22.168, 5.0.1, 5.1.0|
|Reporter:||Yinon Avraham||Assignee:||Yinon Avraham|
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.