Fixed Missing idnex in xf_bookmark_label_use

[mattrogowski]

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.

 

[XF Bug Bot]

Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XF release (2.3.10).

Change log:

Add missing bookmark_id index to xf_bookmark_label_use table

There may be a delay before changes are rolled out to the XenForo Community.