Download wpForo 3.0

AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Forums
wpForo Support Foru...
How-to and Troubles...
wpforo widgets quer...
 
Notifications
Clear all

[Closed] wpforo widgets queries faster?

    Summarize Topic
How-to and Troubleshooting - wpForo 2.0
Last Post by Robert 5 years ago
2 Posts
2 Users
1 Reactions
1,443 Views
RSS
Posts: 533
 CENTRAL4ALL
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
Jun 08, 2021 4:26 pm
(@central4allgmail-com)
Prominent Member
Joined: 8 years ago
[#16930]

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

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

1 Reply
Robert
Posts: 10747
 Robert
Admin
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
Jun 10, 2021 1:24 pm
(@robert)
Support Team
Joined: 3 months 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.

CENTRAL4ALL reacted
Forum Jump:
  Previous Topic
Next Topic  
Share: