Notifications
Clear all

Limited Support

Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed. We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.

 

Woodiscuz has slow query

2 Posts
2 Users
0 Reactions
2,699 Views
(@vofok56817)
New Member
Joined: 4 years ago
Posts: 1
Topic starter  

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
(@astgh)
Illustrious Member Admin
Joined: 8 years ago
Posts: 6450
 

Hi vofok56817,

We'll take this into consideration for future versions. 


   
ReplyQuote
Share:
Scroll to top