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 `loose` mode. In this case, the short code index is not used.
This is a rough list of things that have been observed to have an obvious impact in performance.
excludeBots=true. When the condition is added, the sub-query no longer uses the index and performance drops dramatically.loosemode. In this case, the short code index is not used.