wpForo 1.x.x [Closed] wpforo widgets queries faster?

How-to and Troubleshooting

Last Post by Robert 3 years ago

2 Posts

2 Users

1 Reactions

867 Views

RSS

Posts: 533

CENTRAL4ALL

Topic starter

Jun 08, 2021 12:26 pm

(@central4allgmail-com)

Prominent Member

Joined: 6 years ago

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

`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

wpForoPost->get_posts()

Plugin: wpforo

2.1536

All Suggestions are welcome
https://adultforum.gr/

1 Reply

Posts: 10587

Robert

Admin

Jun 10, 2021 9:24 am

(@robert)

Support Team

Joined: 9 years ago

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.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.