WordPress.org

Ready to get started?Download WordPress

Forums

Broken Link Checker
Create index last_check_attempt in prefix_blc_links (1 post)

  1. staze
    Member
    Posted 2 years ago #

    Whenever BLC is triggered, it does the query:

    SELECT links.* FROM wp_blc_links AS links WHERE (( last_check_attempt < '2011-10-11 17:57:52' ) OR ( (broken = 1 OR being_checked = 1) AND may_recheck = 1 AND check_count < 3 AND last_check_attempt < '2011-10-21 17:37:52' )) AND EXISTS (SELECT 1 FROM wp_blc_instances AS instances WHERE instances.link_id = links.link_id AND ( instances.container_type IN ('dummy', 'page', 'post', 'comment', 'blogroll') )AND ( instances.parser_type IN ('link', 'image', 'url_field', 'metadata') ))ORDER BY last_check_attempt ASC LIMIT 30;

    Problem is, the first part of this query doesn't use an index. So it ends up using filesort, which isn't too bad with only a few links, but with hundreds/thousands, this can be a penalty.

    Anyway, adding an index for "last_check_attempt" to that table allows mysql to use an index for the query, and avoids filesort. Just thought I would pitch this as a feature request.

    http://wordpress.org/extend/plugins/broken-link-checker/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic