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

 Sort Search Results by:

AI Assistant
Notifications
Clear all

[Closed] Performance

16 Posts
3 Users
0 Reactions
13.8 K Views
Robert
Posts: 10736
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
(@robert)
Support Team
Joined: 2 months ago

Hi jost,

thank you for your interest in wpForo and helping to make it better. We just did another test and we have no clue why you get 360 database queries. The topic load queries are 72 wpForo Core + 7 WordPress Core. In total they are 79. Here is the result of our Query Monitor:

Please make sure you don't have other plugins enabled and you've not set hundreds of post per Topic page in settings.


Robert
Posts: 10736
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
(@robert)
Support Team
Joined: 2 months ago

During the last month we've made lots of improvement in wpForo next version. The next 1.2.1 comming soon. At the moment I'd recommend do this small change which may decrease your SQLs 30% off. This was a bug in 1.2.0 version.

Open /wpforo/wpf-includes/class-permissions.php file

Find this line:

if( isset( $this->wpforo->post_options['lang'] ) && $this->wpforo->post_options['lang'] ){

Change to this:

if( isset( $this->wpforo->general_options['lang'] ) && $this->wpforo->general_options['lang'] ){

It should look like this:

 


Posts: 33
 jost
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
(@jost)
Eminent Member
Joined: 9 years ago

Since im new to wpForo, im hoping this is a misconfiguration on my part, because I really want to use it.   As you know dealing with your customers, its very easy for them to screw something up with new software 😉  ( I do support too ).  

The query count was for ALL queries run on a topic/thread page.  I just filtered the wpForo specific queries when reading a thread/topic, and here is a snapshot.

193?-ish queries total.


Posts: 33
 jost
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
(@jost)
Eminent Member
Joined: 9 years ago

I had recently added RECENT TOPICS and RECENT POSTS widget in the sidebar too.  Just an FYI.

 

 

See anything strange????

 

 


Posts: 33
 jost
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
(@jost)
Eminent Member
Joined: 9 years ago

I found something very interesting.

Here is a list of query counts by CALLER.  Look at the total time.

 Even with a lot of queries, it looks very fast to me.  Will dig into what else could be effectively slowing things down.  Its a fast machine.

 

Screen Shot 2017 04 23 at 8.22.51 AM

Page 2 / 4
Share: