[RSS Feed/News] N+1 query behaviour for article forums

[XenForo]

In an article forum there are two possible N+1 query patterns;

1. If a thread/first post is bookmarked
2. If the first post's user is permitted for trusted links.

Spoiler: Stacktrace - bookmark
SELECT xf_bookmark_item.*
FROM xf_bookmark_item

WHERE (xf_bookmark_item.content_type = 'post') AND (xf_bookmark_item.content_id = 9169317) AND...

Read more

ادامه مطلب...