Missing idnex in xf_bookmark_label_use

[mattrogowski]

We've found that on a forum with very high bookmark activity, the query in XF\Repository\Bookmark::getLabelUseCache() can be quite slow, and if run a lot can cause performance issues. It has a composite index for label_id and bookmark_id, but the hosting company added an index for just bookmark_id and it made a significant difference.

Continue reading...