Notifications
Clear all

Woodiscuz has slow query

2 Posts
2 Users
0 Reactions
2,232 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: 7 years ago
Posts: 6177
 

Hi vofok56817,

We'll take this into consideration for future versions. 


   
ReplyQuote
Share:
Scroll to top