Optimized List Queries by Xon

Optimized List Queries by Xon 2.12.0

No permission to download
Overview FAQ Updates (24) Reviews (4) History Discussion
@DavidXLD this add-on can help with conversation list performance. Especially if the 'Better Conversation List Page Threshold' option is set to 0 (note; must update this add-on!)
 
Is there any downside or expected issue if I set all the page thresholds to 1?
So it will always apply even on small forums, conversation, etc.

Thanks.
 
Not really, the overhead is trivial for smaller forums so I've been thinking of adjusting the defaults haven't gotten around to it.
 
  • Like
Reactions: rdn
alfaNova said:
Thank you so much. Some addons require minimum 2.3, so I want to be sure before update the addon.
Click to expand...
The addon releases will usually specify if it's for 2.3 only or cannot be used with anything prior to 2.3.x.
It's good to be cautious, but I think developers have been good at labeling releases that are for 2.3+ only.
 
ENF said:
The addon releases will usually specify if it's for 2.3 only or cannot be used with anything prior to 2.3.x.
It's good to be cautious, but I think developers have been good at labeling releases that are for 2.3+ only.
Click to expand...
If your install doesnt support the plugin it wont install. There is a failsafe.
 
  • Like
Reactions: ENF
I always recommend doing a test install on a staging/test board before deploying to a live environment.
 
  • Like
Reactions: ENF
I have downloaded this plugin for my XF 2.1.3, for a week it worked pretty well. But now I see outages like 503 not available, and the db load is almost 90%. I tried to see the slow query log, and I found a lot of this:

# Time: 2024-12-09T13:19:05.468656Z
# Query_time: 36.935143 Lock_time: 0.000003 Rows_sent: 25 Rows_examined: 95
SET timestamp=1733750308;
SELECT xf_thread., xf_user_User_1., xf_user_LastPoster_2.*
FROM (

SELECT xf_thread.thread_id
FROM xf_thread

WHERE (xf_thread.node_id = 2) AND ((xf_thread.discussion_state IN ('visible'))) AND (xf_thread.sticky = 0)
ORDER BY xf_thread.view_count DESC

LIMIT 25 OFFSET 582850
) as earlyJoinQuery_3
JOIN xf_thread ON ((xf_thread.thread_id = earlyJoinQuery_3.thread_id))
LEFT JOIN xf_user AS xf_user_User_1 ON (xf_user_User_1.user_id = xf_thread.user_id)
LEFT JOIN xf_user AS xf_user_LastPoster_2 ON (xf_user_LastPoster_2.user_id = xf_thread.last_post_user_id)
ORDER BY xf_thread.view_count DESC

LIMIT 25;

So I am wondering why all of a sudden the queries are taking a lot of time. Could it be due to overload of requests? Shall I increase the db capacity?
 
You must log in or register to reply here.
Back
Top Bottom