wpforo widgets queries faster? - How-to and Troubleshooting - wpForo 2.0 https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-widgets-queries-faster/ Discussion Board en-US Wed, 12 Aug 2026 05:27:48 +0000 wpForo 60 RE: wpforo widgets queries faster? https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-widgets-queries-faster/#post-54439 Thu, 10 Jun 2021 09:24:08 +0000 The speed of quires depends on the MySQL/MariaDB version, on your server performance and on the correct indexes of tables. I'd recommend using MySQL 5.7 or MariaDB 10.4.x. Also, you can  decrease the number of items to be selected in widgets and remove all filters. The settings of widgets have a great impact on the queries speed.

]]> How-to and Troubleshooting - wpForo 2.0 Robert https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-widgets-queries-faster/#post-54439 wpforo widgets queries faster? https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-widgets-queries-faster/#post-54396 Tue, 08 Jun 2021 12:26:18 +0000 How can i make these quaries run faster ?

They delay the page 5 secs

 

SELECT SUBSTRING_INDEX( GROUP_CONCAT(`postid`
ORDER BY `created` DESC), ',', 1 ) postids
FROM `wp_wpforo_posts`
GROUP BY `topicid`
ORDER BY MAX(`postid`) DESC
LIMIT 0,65		  
  1. wpForoPost->get_posts()
 Plugin: wpforo 65 2.5420
SELECT SUBSTRING_INDEX( GROUP_CONCAT(`postid`
ORDER BY `created` DESC), ',', 1 ) postids
FROM `wp_wpforo_posts`
GROUP BY `topicid`
ORDER BY MAX(`postid`) DESC
LIMIT 0,20		  
  1. wpForoPost->get_posts()
 Plugin: wpforo 20 2.1536
]]> How-to and Troubleshooting - wpForo 2.0 CENTRAL4ALL https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-widgets-queries-faster/#post-54396