Slow queries in Recent Posts Widget
Quote from StephanK on March 16, 2022, 10:25 amAccording to my Hosting Provider (Mittwald.de), this query used in the recent_post_widget.php is running too long.. stalling PHP processes and is ultimately crashing my whole site
Line 69:
SELECT MAX(p.id) AS id FROM {$this->asgarosforum->tables->posts} AS p LEFT JOIN {$this->asgarosforum->tables->topics} AS t ON (t.id = p.parent_id) WHERE p.forum_id IN({$available_forums}) AND t.approved = 1 GROUP BY p.parent_id ORDER BY MAX(p.id) DESC LIMIT {$number};”
I’d like to continue using this widget – and it used to work fine until yesterday.
I’ve asked if a higher performance server would fix the issue, and was told “No”. I am a bit at a loss.
Any ideas?
According to my Hosting Provider (Mittwald.de), this query used in the recent_post_widget.php is running too long.. stalling PHP processes and is ultimately crashing my whole site
Line 69:
SELECT MAX(p.id) AS id FROM {$this->asgarosforum->tables->posts} AS p LEFT JOIN {$this->asgarosforum->tables->topics} AS t ON (t.id = p.parent_id) WHERE p.forum_id IN({$available_forums}) AND t.approved = 1 GROUP BY p.parent_id ORDER BY MAX(p.id) DESC LIMIT {$number};”
I’d like to continue using this widget – and it used to work fine until yesterday.
I’ve asked if a higher performance server would fix the issue, and was told “No”. I am a bit at a loss.
Any ideas?
Quote from Asgaros on March 6, 2023, 4:53 amI will check the details and will fix it as soon as possible:
https://github.com/Asgaros/asgaros-forum/issues/364
I will check the details and will fix it as soon as possible: