Known performance bottlenecks #2293
Description
This is a rough list of things that have been observed to have an obvious impact in performance.
- Listing tag visits with
excludeBots=true. When the condition is added, the sub-query no longer uses the index and performance drops dramatically. - Matching a short URL in
loosemode. In this case, the short code index is not used.