gVectors Team

Professional WordPress Plugins and Services. wpDiscuz, WooDiscuz, Advanced Post Pagination

Search
Close
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
Plugin Support
Other Plugins
WooDiscuz - WooComm...
Woodiscuz has slow ...
 
Notifications
Clear all

Woodiscuz has slow query

  ✦ Summarize Topic
WooDiscuz - WooCommerce Comments
Last Post by Astghik 5 years ago
2 Posts
2 Users
0 Reactions
3,448 Views
RSS
 vofok56817
(@vofok56817)
New Member
Joined: 5 years ago
Posts: 1
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
18/05/2021 7:30 am   [#7754]

Hi,

 

Why you use LIKE in get_comment_count()??

You should use

"WHERE c.`comment_type` == 'woodiscuz'"

insted of:

"WHERE c.`comment_type` LIKE 'woodiscuz'"

 

LIKE is very slow comparison.

 

If you say, "oh its for backward compatibility". But you already update all of that comment_type in update_comments_types_2_2_0()



   
Quote
Astghik
 Astghik
(@astgh)
Illustrious Member Admin
Joined: 8 years ago
Posts: 6645
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
18/05/2021 4:31 pm  

Hi vofok56817,

We'll take this into consideration for future versions. 



   
ReplyQuote
Forum Jump:
  Previous Topic
Next Topic  
Share:
Scroll to top