[RTFACT-18595] Improve the time/efficiency of the "Artifact Count / Size" query in the UI Created: 25/Feb/19 Updated: 05/Jun/19
|Project:||Artifactory Binary Repository|
Currently, when having a big repository with a lot of artifacts, running the "Artifact Count / Size" count can take a while. Need to check if it's possible to improve the query in order to have better results (speed wise).
The SQL query that is being used is in Derby:
Here is an example of running the query:
Most likely that this query is related to the following factors: