I an updating a tool I missed in the initial rounds of the actor/comment
table changes. This query used to run in ~30 seconds or so. Now its at a
staggering 10 minute run time. Anyone able to lend a hand on getting this
optimized?
select log_timestamp, actor_name, log_action, log_title, comment_text,
log_params
from logging_userindex
left join actor_logging on actor_id = log_actor
left join comment_logging on comment_id = log_comment_id
where log_type = 'block' and log_namespace = 2 and
log_title like '%s%%'
order by log_timestamp;