Open myrmoteras opened 6 months ago
Not sure what might have slowed this one down when you tried it, but I just ran the same query, also varying the limit to ensure cache misses, and it was decently fast each time ... could be you hit (a) a garbage collection event in Tomcat or the back-end, or (b) collided with a burst of other queries ... hard to tell, really. Please keep an eye on this and see if it repeats ... impossible to investigate a single instance of a query taking longer than normal.
PS: please note that this is the Treatment Stats, not SRS proper ... the latter uses a completely separate index structure, and also assembles results in a different way, namely fuzzy and based upon a relevance score.
when search SRS using part of an author name
%Kjaerandsen%
, SRS is very slow eg. >1min for https://tb.plazi.org/GgServer/srsStats/stats?outputFields=doc.articleUuid+bib.author+pubLnk.articleDoi+pubLnk.articleGbifId+pubLnk.articleClbId+matCit.gbifOccurrenceId+matCit.typeStatus&groupingFields=doc.articleUuid+bib.author+pubLnk.articleGbifId+pubLnk.articleClbId+matCit.gbifOccurrenceId+matCit.typeStatus&FP-bib.author=%25Kjaerandsen%25&FP-matCit.gbifOccurrenceId=1-&format=HTML