Missing idnex in xf_bookmark_label_use

mattrogowski

Well-known member
Affected version
2.2, 2.3
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.
 
Back
Top Bottom