Affects Version/s: None
Fix Version/s: None
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:
- DB type.
- DB machine specs.
- Load on the DB at the time the query was executed.