XF 2.3 MySQL process Q

[pilot823]

Example
Select xf_thread,thread_id from xf_thread where xf_thread.title rlike '......

When we get more the 15 to 25 ahow up a time on the backend. Are Forum slow down to a craw. Any Suggest on how to fix this issue?.

 

[pilot823]

Can anyone help explain why are forum is having these issues.

 

[Mike Fara]

RLIKE forces a full table scan, use LIKE instead

 

[pilot823]

RLIKE forces a full table scan, use LIKE instead

I will try that put

 

[pilot823]

Rlike and like does the same thing.