Jump to content

Slow performing query

Recommended Posts

This query is consistently performing slow. Any thoughts from where it's coming and how can I improve the performance? Thanks


# Time: 2021-03-20T20:47:29.558248Z
# User@Host: xxxx[xxxx] @ localhost []  Id: 2551630
# Query_time: 35.480665  Lock_time: 0.000047 Rows_sent: 5  Rows_examined: 2423624
use xxxx;
SET timestamp=1616273249;
/*xxxx::xxxx::IPS\Content\_WidgetComment::render:833*/ SELECT forums_posts.*, forums_topics.* FROM `ipb_forums_posts` AS `forums_posts`  STRAIGHT_JOIN `ipb_forums_topics` AS `forums_topics` ON forums_posts.topic_id=forums_topics.tid AND forums_topics.approved=1 AND forums_topics.approved!=-2 AND forums_topics.approved !=-3  LEFT JOIN `ipb_forums_forums` AS `forums_forums` ON forums_topics.forum_id=forums_forums.id AND forums_forums.password IS NULL AND forums_forums.can_view_others=1 AND ( forums_forums.password IS NULL OR ( FIND_IN_SET(2,forums_forums.password_override) ) ) AND forums_forums.min_posts_view<=0 WHERE forums_forums.can_view_others=1 AND queued=0 AND forums_posts.queued!=-2 AND forums_posts.queued !=-3 AND forums_topics.forum_id IN(4,8,11,12,13,24,26,38,42,49,52,53,68,69,75,76,77,81,83,124,125,128,133,134,135,138,143,159,171,172,181,193,195,196,197,198,199,201,202,205,206,207,208,209,210,211,213,218,220,221,224,238,245,246,247,248,249,251,252,254,255,256,257,258,259,260,262,263,266,269,270,275) ORDER BY post_date DESC LIMIT 5;


Edited by AlexJ
Link to comment
Share on other sites

12 minutes ago, Daniel F said:

It’s a comment feed widget ( 


and based on the query I guess the last 5 posts in your community 

Using default IPS widget. It has performance issue? Should i disable it? If its last 5 post then why it's examining: rows_examined: 2423624

Shouldn't be in last 24 hrs or something or by timestamp? 

Update: I see this option: Going to use it. Let's see.


Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...