RSS Feed/News Missing idnex in xf_bookmark_label_use

Status
Not open for further replies.

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
30,470
Points
823

Reputation:

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...
 
Status
Not open for further replies.
Top