-
Type:
Improvement
-
Status: Open
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Labels:
Edit:
Package search - Maven GAVC in UI without GroupId has a really bad performance. A search request, if you don’t know the GroupId (a common use case) lasts about 2 minutes. The same search via API lasts 8 seconds.
GAVC search in UI takes too long to respond when you leave Group ID empty or provide a wildcard.
When this field is left empty or just a wildcard is provided, the SQL query also uses a wildcard for the LIKE operator in the search query. When using only the wildcard for LIKE operator SQL does not use the indexes in the table and the search takes too long to respond.
We need to add a message in the UI when GAVC search is used. Something like this "Please do not leave the Group ID field empty and also don't provide only a wildcard, as this will cause the search to be slow"