The effects of alcohol on sustanon 250 leucine for – real weight loss & bodybuilding benefits?
Search
Close
AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

Filter by custom fields

Topic prefix

AI Assistant
Forums
Community Support
Bug Reports
Wpdiscuz has slow q...
 
Notifications
Clear all

Wpdiscuz has slow query

  ✦ Summarize Topic
Bug Reports
3 Posts
2 Users
0 Reactions
1,267 Views
RSS
 vofok56817@to200.com
(@vofok56817to200-com)
Posts: 4
Active Member
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
 
[#2054]

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()


 
Posted : 16/05/2021 4:19 pm
Topic Tags
slow query
Asti
 Asti
(@asti)
Posts: 8257
Illustrious Member Support
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
 

You're asking your question in a wrong forum. This is wpDiscuz plugin support forum. 


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

 
Posted : 17/05/2021 4:28 pm
 vofok56817@to200.com
(@vofok56817to200-com)
Posts: 4
Active Member
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
 

Im realy sorry I dont know woodiscuz and wpdiscuz is from different company. Can you point me where to post this?


 
Posted : 18/05/2021 7:12 am
Forum Jump:
  Previous Topic
Next Topic  
Topic Tags:  slow query (1) ,
Share: