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 March 20, 20214 yr by AlexJ

It’s a comment feed widget ( 

xxxx::xxxx::IPS\Content\_WidgetComment::render 

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

12 minutes ago, Daniel F said:

It’s a comment feed widget ( 

xxxx::xxxx::IPS\Content\_WidgetComment::render 

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.

Is that a default IPS widget though? Last I checked none of my widgets have this.

4 hours ago, Morrigan said:

Is that a default IPS widget though? Last I checked none of my widgets have this.

I thought it's default IPS widget. I don't recall adding something like that. 

You'll probably want to submit a ticket with the details of all the choices that you are using on the widget so that IPS can investigate it.